Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Import issue  (Read 3418 times)

Offline Sam_78

  • Sr. Member
  • ****
  • Posts: 270
  • Karma: +42/-1
    • View Profile
Import issue
« on: September 07, 2018, 04:56:14 PM »
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
« Last Edit: September 07, 2018, 05:20:16 PM by Sam_78 »

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Import issue
« Reply #1 on: September 10, 2018, 01:26:25 AM »
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

Offline Sam_78

  • Sr. Member
  • ****
  • Posts: 270
  • Karma: +42/-1
    • View Profile
Re: Import issue
« Reply #2 on: September 10, 2018, 11:44:20 AM »
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?

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Import issue
« Reply #3 on: September 11, 2018, 01:05:20 AM »
You can try to export your products to CSV check/fill store column and import back

 

Powered by SMFPacks Social Login Mod