Trying to Import New Products received and Export Pro is saying ID is mandatory

itsupport-micheleperesso

Trying to import some new products we received in stock based on template generated from Export Pro. Since the products are new, there is no ID yet. How can these new products be imported if importer is saying that ID is mandatory?

Salva

Hi itsupport-micheleperesso

If what you want is to create new products, do not use the "UPDATE" option when importing, use the "INSERT" instead.
Only in the case you want to update existing products, the ID is mandatory because the plugin needs to know which products to update. So you can export all your products, include the IDs and edit the CSV to alter the columns you want to edit and import the file back.

I hope this helps.

Best Regards,
Salva.

itsupport-micheleperesso

Thanks Salva for reaching out. I used the INSERT feature, and in the import profile ID is set to 'Do not import' and plugin complains just the same that

Import aborted
Not all required fields were included in the import (ID from product).

If INSERT feature is being performed to create new products and ID is not known and Import Template says not to import ID, then this plugin is broken. It should logically attempt to insert into new 'products' and create new IDs.

japiera

Hi itsupport-micheleperesso ,

The ID field is mandatory, regardless of the import method you use (insert or update). This is due to some ATUM Export internal requirements.

Please include the column in your CSV file. It doesn't matter if you leave it blank; it must be present.

Best Regards,
José Andrés

itsupport-micheleperesso

Yes Jose, column is being included, and is being left empty as you indicated and import with INSERT is returning the indicated error. Can supply sample import file being used for reference. And would also require to import barcode. How is this possible please?

japiera

Hi itsupport-micheleperesso ,

I've just tested the insert process, including the ID column with an empty value and the product was imported properly.

Please open a private ticket here and include the CSV file you're trying to import. Please also attach the template you use to import (if it's a custom template).

You can read here how to export and attach custom templates from your site.

As for the barcode field, it is not included in our default product template, but you can add it when creating a new custom template. Please check the image below.

You can read about creating custom templates in this article.

Best Regards,
José Andrés

itsupport-micheleperesso

Issue has been traced to ID field name being case sensitive, when compared to template. Thanks for the clarification.

japiera

Hi itsupport-micheleperesso ,

We're glad you could finally find the cause and correct it.

Best Regards,
José Andrés