Author Topic: Import (Upload) Products via CSV format  (Read 20630 times)

Offline quenncy

  • Newbie
  • *
  • Posts: 25
  • Karma: +2/-0
    • View Profile
Import (Upload) Products via CSV format
« on: October 31, 2012, 01:31:31 AM »
What columns are REQUIRED in a product import (Insert) CSV file for the products to go straight in the storefront for sale without any having to tweak each one individually in the products page ?

Thanks in advance,
Q :)

Offline Faster

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: Import (Upload) Products via CSV format
« Reply #1 on: November 02, 2012, 11:11:46 AM »
Hello
For import products from CSv file without the need to configure each product separately, your archive with CVS files must contain next CVS files (not columns)
Blocks
Categories
Manufacturers
Products
Resource_library
Resource_types

Thanks for question)

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4152
  • Karma: +251/-9
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Import (Upload) Products via CSV format
« Reply #2 on: November 02, 2012, 11:15:39 AM »
Apologies for missing user manual for import/export. We are closing the gap and It will be available soon.

In addition, more control for import/export will be added in next version.

Patience and help greatly appreciated.



We need your help to build better free open source eCommerce platform for everyone.
See how you can help

Offline quenncy

  • Newbie
  • *
  • Posts: 25
  • Karma: +2/-0
    • View Profile
Re: Import (Upload) Products via CSV format
« Reply #3 on: November 04, 2012, 12:07:20 PM »
Apologies for missing user manual for import/export. We are closing the gap and It will be available soon.

In addition, more control for import/export will be added in next version.

Patience and help greatly appreciated.

No Apologies needed I totally understand somethings take time.
Thank You for all that you and your community does! I know I greatly appreciate it very much.

Thanks Again,
Quenncy

Offline quenncy

  • Newbie
  • *
  • Posts: 25
  • Karma: +2/-0
    • View Profile
Re: Import (Upload) Products via CSV format
« Reply #4 on: November 04, 2012, 12:55:51 PM »
Hello
For import products from CSv file without the need to configure each product separately, your archive with CVS files must contain next CVS files (not columns)
Blocks
Categories
Manufacturers
Products
Resource_library
Resource_types

Thanks for question)

1. So let me see if I got this right or not, Once you are completed in excel make sure you save it in a CSV format that is "next CVS files (not columns)" and everything separated by my choose of a "comma"?
2.  Also where do you put your URL for the products image that you want the system to capture and use in your store?  I am including a attachment showing you what I have from my supplier to use and build a cvs file for importing into the system maybe it will better help you explain where all I need to put it? Also all products are Free Shipping but are sold only to the US & Canada.

Thanks so much,
Quenncy

« Last Edit: November 04, 2012, 03:07:23 PM by quenncy »

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 4275
  • Karma: +202/-0
    • View Profile
Re: Import (Upload) Products via CSV format
« Reply #5 on: November 05, 2012, 05:35:17 AM »
2.  Also where do you put your URL for the products image that you want the system to capture and use in your store?

Hi. Looks like AbanteCart cannot capture image URLs
“Chuck Norris is so amazing.”
― Mother Teresa

Offline quenncy

  • Newbie
  • *
  • Posts: 25
  • Karma: +2/-0
    • View Profile
Re: Import (Upload) Products via CSV format
« Reply #6 on: November 05, 2012, 12:06:01 PM »
2.  Also where do you put your URL for the products image that you want the system to capture and use in your store?

Hi. Looks like AbanteCart cannot capture image URLs

So I am confused on why to use the CSV importing process if it can't include images, I mean if you have to upload multiple images for every item (1000 or more) then what is the whole idea about.

Trying to understand the thought here.

Thanks,
Quenncy

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 4275
  • Karma: +202/-0
    • View Profile
Re: Import (Upload) Products via CSV format
« Reply #7 on: December 11, 2012, 02:40:12 AM »
Quote from: quenncy
So I am confused on why to use the CSV importing process if it can't include images, I mean if you have to upload multiple images for every item (1000 or more) then what is the whole idea about.

In AbanteCart v1.1.2 you can upload images via FTP to ./resources/image/ folder and modify your SCV file with correct file names and path.

See SCV examples for INSERT at the bottom of this page http://docs.abantecart.com/pages/tools/import.html
« Last Edit: November 01, 2016, 08:29:43 AM by Basara »
“Chuck Norris is so amazing.”
― Mother Teresa

 

Powered by SMFPacks Social Login Mod