News:

AbanteCart v1.4.2 is released.

Main Menu

Do you like AbanteCart? Please rate AbanteCart or share your experience with other eCommerce entrepreneurs. Go to Softaculous rating page to add your rating or write a review

Import issue

Started by Sam_78, September 07, 2018, 04:56:14 PM

Previous topic - Next topic

Sam_78

Hi I imported 4,269 products from a csv file
in dropdown I selected product table and then selected fields
my CSV file only had status, SKU, product name, cost, sell price and manufacture so I mapped those fields and clicked on load it was completed without any errors in error log.
this is the file that was generated products_import_1.txt and it says this:

2018-09-08 2:15:30 - Error: Missing images data array for products.
2018-09-08 2:15:30 - Processing record for product Macallan 10yrs 2798 .
2018-09-08 2:15:30 - Created product 'Macallan 10yrs' with ID 2110
2018-09-08 2:15:30 - Error: Missing images data array for products.
2018-09-08 2:15:30 - Processing record for product Ciroc Coconut 2799 .
2018-09-08 2:15:30 - Created product 'Ciroc Coconut' with ID 2111

Do I need to have an image because I don't see image as a required value.

Task has been completed
Import Process has been completed. 4269 row(s) processed.
For more details see log file products_import_1.txt

after it says 4269 products have been loaded I do see them in products table and manufacturers are inserted in their table and I can see those manufacturers in store admin panel but I don't see them in catalog->products can someone help me
I have cleared browser cache and system cache. Version = 1.2.12

Basara

Hello.
It looks like products were loaded but not assigned to store.
I remember some related fixes in 1.2.13

in database assign your products to default store id. Usually it is 0 or 1

Sam_78

ok so after importing all the products we need to add all the new product_id into `products_to_stores` table with store_id = 0 right?

Basara

You can try to export your products to CSV check/fill store column and import back

Forum Rules Code of conduct
AbanteCart.com 2010 -