Different Product_Code

  • Posts: 11
  • Thank you received: 0
13 years 5 months ago #17612

I have a product that has different product SKUs based on color. Is there a way to have one product listing but show the correct SKU on the purchase documents when it's purchased?

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

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
13 years 5 months ago #17618

Yes. If you create a characteristic and add that characteristic to your product, you will get several variants of your product and each one will have its own code (sku). Then, when the user select the characteristic and add the product to the cart, the corresponding variant is added and the user will be able to see the product code in the invoice.

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

  • Posts: 11
  • Thank you received: 0
13 years 5 months ago #17621

Currently I'm trying to upload the products from a CVS file. The variants are tied to the product_code of the loaded product. (I'm loading a default product_code because I only want the one product listing.) The variant code has the format of "product_code"_variant_1. I don't understand how I could change the variant code to show a different "product_code" and still associate it with the correct product. Am I missing something?

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

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
13 years 5 months ago #17625

Could you give an example of product information in your CSV ?

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

  • Posts: 11
  • Thank you received: 0
13 years 5 months ago #17628

Here is an example. I have a product with the characteristics of size, color & length. Each of the three colors have a different SKU.
Beige = 10000001
Khaki = 10000002
White = 10000000
Then the size and length is appended on the SKU to generate the final unique identifier.
How should this be address in the upload file?

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

  • Posts: 11
  • Thank you received: 0
13 years 5 months ago #17629

I'm didn't upload the file a as CVS type.

File Attachment:

File Name: Womens_Bre...mple.csv
File Size:2 KB

Attachments:

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

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
13 years 5 months ago #17631

Your CSV is not correct.
On the first one, you have that:
10000001,,10000001.jpg
But the three first columns are:
product_code,images,product_parent_id
The image should be in the second column, not the third.

I see that you didn't specify any product code on your other lines so HikaShop will generate it automatically.
Also, I see that in your product_parent_id column for your variants you didn't specify the product_code of the parent but something like that: 10000001_variant_X

If I'm following you, the product code of the first variant should be 1000000022Regular, so the first variant line in your CSV should start with this:
1000000022Regular,,10000001
First, the code of the variant, then the images if any, and then the code of the main product.

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

  • Posts: 11
  • Thank you received: 0
13 years 5 months ago #17634

That helps. I appreciate your quick response and excellent help.

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

Time to create page: 0.065 seconds
Powered by Kunena Forum