AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: rvalani on July 13, 2016, 05:01:50 PM

Title: Can't import products
Post by: rvalani on July 13, 2016, 05:01:50 PM

Hi,
I already have one website running and want to copy the same products to new one so I went through documentation and followed the steps but csv file is not coming in expected format and the csv file I have from old project is different please help me merge it and import it..
I am getting this error "Incorrect structure of main Array node. Only table nodes are expected"
Thanks

Title: Re: Can't import products
Post by: Basara on July 14, 2016, 05:05:41 AM

Hello.
What do you mean "is not coming in expected format"?
Also check Cart migration tool it may help with few carts http://docs.abantecart.com/pages/tools/migration.html

Title: Re: Can't import products
Post by: rvalani on July 18, 2016, 06:04:50 PM

I am running locally as of now so I have two stores
In one store I have entered all products manually and in other I have used extension > Import method where I have exported the products.csv and categories.csv and pasted in the new products  it was successfull but I couldn't get the images
P.S I have copied images from old project to the new ones at the new destinations

Title: Re: Can't import products
Post by: Basara on July 19, 2016, 02:41:21 AM

Hello.

AbanteCart store images in Resource Library so you need to export RL too. Additionally you can move your store in other way see http://docs.abantecart.com/pages/tips/change_domain.html#ChangeHosting

Title: Re: Can't import products
Post by: mattpb on August 21, 2016, 03:52:27 AM

I have still had zero success importing products through the AbanteCart CSV/TXT/XML Importer.  I have thousands more to do and need to figure out what I'm doing wrong.  It'll give me a count of successful queries and listings created, but then I always get an error and it seems to knock each row (line item, listing) out and I end up with no change to Inventory or Database when checking phpMyAdmin.  These are the latest  error messages I'm getting:
Missing relation ID category_id for update_or_insert action in table products_to_categories. Skipping.
Missing relation ID category_id for update_or_insert action in table products_to_categories. Skipping.
Missing relation ID category_id for update_or_insert action in table products_to_categories. Skipping.
...

Title: Re: Can't import products
Post by: abantecart on August 21, 2016, 10:30:34 AM

Can you post import file sample? Include only 2-3 records in the sample.

Title: Re: Can't import products
Post by: mattpb on August 25, 2016, 11:37:32 PM

Thank you for your reply.  I figured out the problem to this particular issue and will share my conclusion for the benefit of the community.  I exported a full product (meaning every product table) CSV from the admin panel.  Thus there were multiple "product_id" columns in the spreadsheet, ordered as they appeared in certain tables (i.e. _product_description table has a product_id column, as does _product_categories, and so on).  The real mistake I made was filling in the product_id column that was part of the "products to categories" table with our id numbers, but not having a associated category id to all of the product ids listed.  Hence the error message.  I went back and corrected this and the upload was successful, even though prices and dates were off because I used Excel.  Trial and error, lol.