AbanteCart Community

Shopping Cart Operations => Support => Topic started by: Old-Paul on December 10, 2023, 07:28:11 PM

Title: Import errors and how to resolve.
Post by: Old-Paul on December 10, 2023, 07:28:11 PM

This is my first attempt to use AbanteCart cart and one of the reasons I chose it was the import capabilities.

I am having some issues with import and have the following errors but not sure how to resolve them due to lack of clarity of what the errors mean.

I'm assuming has to do with the fields/data in the CSV file.  One question is on a product import what is the correct name of the field to designate what category those products belong in? I looked in examples and cannot find a field that would seem to place imported products into a designated catatory.

insert data error in products. SQL Error: Unknown column 'category' in 'field list'

and

Missing relation ID tag for update_or_insert action in table product_tags

and

Insert data error for resource_map SQL Error: Duplicate entry '0-products-0' for key 'PRIMARY'

Any help appreciated.

Title: Re: Import errors and how to resolve.
Post by: Basara on December 11, 2023, 02:59:40 AM

Hello.
Please attach the CSV file you import. Worth noting that AbanteCart supports two different formats for the import process. Most easiest for beginners is this https://abantecart.atlassian.net/wiki/spaces/AD/pages/16777227/Import+Wizard

Title: Re: Import errors and how to resolve.
Post by: Old-Paul on December 11, 2023, 04:44:44 PM

I will try private message due to bug in this forum.

Sorry, you are not allowed to post external links

I had zero links in my reply?  Hope admins fix this as it appears if you discuss fields in import files this form seems to think they are a URL.

Title: Re: Import errors and how to resolve.
Post by: Old-Paul on December 11, 2023, 08:50:36 PM

Quote from: Old-Paul on December 11, 2023, 04:44:44 PM

I will try private message due to bug in this forum.

Sorry, you are not allowed to post external links

I had zero links in my reply?  Hope admins fix this as it appears if you discuss fields in import files this form seems to think they are a URL.

This turned out to be a big help!  Thank you many times.

I now have configured my own CSV which works every time using your example as a guide.  I remove a lot of columns from data file to narrow to a small set relative to my needs.

Have a great holiday!

Title: Re: Import errors and how to resolve.
Post by: Basara on December 12, 2023, 02:46:40 AM

Hello.
To prevent spam, the forum restricts new users from posting direct links. You need to earn a +20 reputation to post links.