Product data/images imported into incorrect product record

  • Posts: 211
  • Thank you received: 14
  • Hikashop Business
3 weeks 22 hours ago #369609

-- HikaShop version -- : 6.1.1
-- Joomla version -- : ‎5.4.1
-- PHP version -- : 8.2.14
-- Browser(s) name and version -- : Firefox 145.0.1
-- Error-message(debug-mod must be tuned on) -- : no error message

We are importing products on a scheduled basis from a CSV file. We noticed that some product data was being imported into an existing product that was not the same product as what was being imported, instead of creating a new product. We believe we've tracked it down to an issue with product codes being too similar and Hikashop potentially not taking into consideration the full product code.

For example, we have several products that have codes like:
Brookstone-1234
Brookstone-1432
Brookstone-1342

Regency-1234
Regency-1324
Regency-1432

What we're seeing is that in some cases, the product is missing but the product's images/data were imported into a different product of a similar name - eg. Brookstone-1432 doesn't exist but Brookstone-1234 contains images for Brookstone-1432.

We have many other products importing without any issue. It's only products that have these similar product codes that are being erroneously merged in some cases.

3by400, Inc.
3by400.com
Websites that Work, Marketing that Matters

Please Log in or Create an account to join the conversation.

  • Posts: 211
  • Thank you received: 14
  • Hikashop Business
3 weeks 21 hours ago #369611

Here's a case where the product image was imported into a variant of a different product.

This message contains confidential information


This message contains confidential information

3by400, Inc.
3by400.com
Websites that Work, Marketing that Matters

Please Log in or Create an account to join the conversation.

  • Posts: 84863
  • Thank you received: 13817
  • MODERATOR
3 weeks 9 hours ago #369613

Hi,

The system is supposed to use the product_code matching exactly. However, if there is a product_id column, then the product_id will be taken into account instead.
Also, if you have a number in the product_code column, it will try to match a product_id with it.
Finally, if there are no product_code nor product_id columns in the CSV, then the system will generate the product_code from the product_name and then try to match the product_code with existing products.

It would be interesting to get a copy of the CSV file in order to check what is in it.

Please Log in or Create an account to join the conversation.

  • Posts: 211
  • Thank you received: 14
  • Hikashop Business
2 weeks 6 days ago #369626

The CSV file is available at the URL below:

This message contains confidential information


BROOKSTONE-003125 is the first product but the product wasn't created upon import. Instead, it's images were imported into the second product, BROOKSTONE-003577.
This message contains confidential information


For some reason BROOKSTONE 3793's variant - 17181B - has the imported price from one of the Regency products.
This message contains confidential information


REGENCY-003730's variant - 16988C - has the image for REGENCY-003811 imported into it.
This message contains confidential information

3by400, Inc.
3by400.com
Websites that Work, Marketing that Matters

Please Log in or Create an account to join the conversation.

  • Posts: 84863
  • Thank you received: 13817
  • MODERATOR
2 weeks 6 days ago #369629

Hi,

BROOKSTONE-003125 is the first product but the product wasn't created upon import. Instead, it's images were imported into the second product, BROOKSTONE-003577.

I'm not following you.
You have the "product_id" column in your CSV. This means that the products in the CSV are already in the database, and the data in the CSV will update the products in the database based on the ids in that column.
In your CSV, the product "BROOKSTONE-003125" has the product_id "1". And thus, during the import, the system will update the product with that product_id with the data from the CSV.

And I suppose the problem is the same with the rest. The product_id column being there, the system tries to update products / variants based on it. If you have different things in the database which don't match with the product_id, the import will behave erratically compared to what you expect based on the product_code column.
That's basically what I was saying in my previous message.

The following user(s) said Thank You: 3by400

Please Log in or Create an account to join the conversation.

  • Posts: 211
  • Thank you received: 14
  • Hikashop Business
2 weeks 6 days ago #369640

Understood. Thank you.

3by400, Inc.
3by400.com
Websites that Work, Marketing that Matters

Please Log in or Create an account to join the conversation.

Time to create page: 0.062 seconds
Powered by Kunena Forum