Categories
View Replies (1)

Resolved Multiple manufacturers

  1. LaScuderia
    LaScuderia
  2. RO CSVI
  3. Saturday, 26 January 2019
  4.  Subscribe via email
Hi,

In order to sort our products better we would like to assign (and slightly abuse) the manufacturer field for this.

When running an export on manufacturer_name i saw that different names are seperated by a pipe. On import however, for every reoccuring manufacturer, a new manufacturer is created. Even though the manufacturer already exists.

I tried going around this and instead point to the manufacturer_id of the manufacturer, seperated by pipes again. This did not work, some categories were created but the import would error out with Duplicate entry '0' for key 'PRIMARY'.

Can you give us some advice on how to import with multiple manufacturers?

Thanks!
0
Responses (1)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
You should avoid using manufacturer_id field as that is primary key field and it has to be handled by the database itself. You should use manufacturer_name field instead. As per the debug log attached, it shows the manufacturers have been to updated to nl_NL(Dutch) table. Is that the language you are using on your site? Also, there is no query which shows new manufacturers have been created. Can you post the debug log of the import using manufacturer_name field?

Duplicate entry '0' for key 'PRIMARY'.

This error means that there is already an entry with id as 0 and a new row with id 0 is inserted.

Can you also post sample of your import file with manufacturer_name field?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!