Author Topic: Import Products CSV  (Read 11218 times)

Offline quenncy

  • Newbie
  • *
  • Posts: 25
  • Karma: +2/-0
    • View Profile
Import Products CSV
« on: October 29, 2012, 01:29:44 PM »
I am trying to understand Importing by CSV to upload many products at one time to my Store Front.

I have manually entered some products to my store then exported the PRODUCT CSV for a example.
Opening the CSV product sample wit excel and deleted all columns that I was not familiar with but leaving columns to data I wanted to enter like "products.price", "products.title", "products.sku" etc.. After completing 163 rows I then saved it back in the same format as I opened then I went to the Import page and tried once to upload with TEST on then tried again with TEST off. Either way I didn't get no errors but have no clue where or if it placed the Added Products data somewhere and I can't find it.

Any help would be appreciated,
Regards,
Quenncy  :)

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4314
  • Karma: +291/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Import Products CSV
« Reply #1 on: October 29, 2012, 02:11:35 PM »
What version of abantecart you use?
When you do import, result page shows you number of record created/updated. What did you get?
You comment
Quote
and deleted all columns that I was not familiar
I am not sure if you deleted some important columns, like column that links product to category.
Please  rate your experience or leave your review
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 Products CSV
« Reply #2 on: October 29, 2012, 02:39:47 PM »
What version of abantecart you use?
When you do import, result page shows you number of record created/updated. What did you get?
You comment
Quote
and deleted all columns that I was not familiar
I am not sure if you deleted some important columns, like column that links product to category.

I want to say thanks so much for the speedy reply.

I am running ver. 1.1 downloaded via my hosting site's cPanel. So I believe it is basically installed to my hosting server.

On "result's" the error reads:
Total loaded: 971. Updated: 0. Created: 809. Errors: 162
"Missing relation ID resource_id for update_or_insert action in table resource_library. Skipping."

Here is a screen shot that might help us on the columns.
Also you can not see but I entered at the very beginning the Column "Action" and for all rows entered "insert".

What columns are REQUIRED in a product import (Insert) CSV file?

Thanks,
Quenncy  :)
« Last Edit: October 29, 2012, 06:26:24 PM by quenncy »

Offline andrew.mikhailyk

  • Newbie
  • *
  • Posts: 25
  • Karma: +5/-0
    • View Profile
Re: Import Products CSV
« Reply #3 on: November 02, 2012, 10:51:34 AM »
Hello Quenncy,

Can you please confirm if you have products at Catalog -> Products page at Control panel after import or not?
Also please give us your import file or part of it.

Thanks.

Offline FG

  • Newbie
  • *
  • Posts: 27
  • Karma: +5/-0
    • View Profile
Re: Import Products CSV
« Reply #4 on: February 18, 2013, 08:34:11 AM »
The import feature is nice and easy to use.  The best way to do it is manually add a product and then perform an export and use that file as a template.

I've tried lots of different platforms and I found the Import feature of AbanteCart the easiest to use.

:)

Offline tiler

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: Import Products CSV
« Reply #5 on: June 08, 2013, 09:07:35 AM »
Hello,
I too am trying to get to grips with imports.
I have a bookstore website and am trying to import csv files from homebase.
I have attached sample file.
Can anyone instruct or guide me to fulfilling this action.
Regards to all.

 

Powered by SMFPacks Social Login Mod