characteristics exists in database type variant!

  • Posts: 16
  • Thank you received: 0
9 years 10 months ago #186538

-- url of the page with the problem -- : 5.10.105.46/~yamity3c/
-- HikaShop version -- : HikaShop Business: 2.3.5
-- Joomla version -- : Joomla! 3.3.0 Stable
-- PHP version -- : 5.3.29
-- Error-message(debug-mod must be tuned on) -- : The product PROWAVE_142 is of the type main but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it.

When trying to import .csv with characteristics it does NOT recognized
the products id with the characteristics I get an error:

The product ..... is of the type main but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it.

Even after I reimport it via the mass action or the import product I still get the same error please help!

M

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
9 years 10 months ago #186549

Hi,

The message is saying that the product with the product code "PROWAVE_142" is already existing in your database as a product code of a variant.
Because you're trying to import such product as a main product, you want to change the type of the product so the import refuse that.

So please
- correct your database by changing the product type.
OR
- correct your database by changing the product code.
OR
- correct your CSV by using another product code.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 16
  • Thank you received: 0
9 years 10 months ago #187174

-- url of the page with the problem -- : 5.10.105.46/~yamity3c/
-- HikaShop version -- : HikaShop Business: 2.3.5
-- Joomla version -- : Joomla! 3.3.0 Stable
-- PHP version -- : 5.3.29
-- Error-message(debug-mod must be tuned on) -- : The product mhTop_2643 is of the type main but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it.

I try to change a price of a product with Characteristics via .csv or mass action (see attached csv file)

product_id | product_name | price_value | mhbot1
4229 | Name1 | 2222 | Value1

Via: import - Error -

The product mhTop_2643 is of the type main but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it.

Via - mass Action - Error -

Notice
The line '' could not be imported Product not found.


I have change:
1. the product type - I have change to main but is not what I need. I need it to be a variant (or what other type a product with Characteristics can be?)

2. Changing the product code. (did not work)
3. Correct your CSV by using another product code. (did not work)

Please assist on how can I change a price value of a product with Characteristics via .csv or mass action

M




I have export a product with Characteristics via cvs with product code. (Attached is an screen shoot image with the way i am exporting the product via mass action.)

Here is the text result (attached a csv too)
"product_id";"product_name";"product_description";"product_code";"catlog_number";"price_id";"price_value"
4229;"Name1";"";"mhTop_2643";"";16590;40.00000

I still can not change the price within a product with Characteristics

Please advise

Thanks
M

Attachments:
Last edit: 9 years 10 months ago by mici. Reason: Change a product with Characteristics via cvs with product code NOT working

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
9 years 10 months ago #187179

Hi,

Please do not create a new thread for the exact same problem.
I already gave you an explanations for the error message ; if you do not understand it you can just say and we will reformulate it.

1. If you need the product to be a variant so ; don't try to replace an existing product which is a "main" one.
2. ok
3. There is no product code in your CSV ; how did you changed it ?

I can only recommend you to use a mass action and not use the import system.
The import system has been made to import ALL information of a product ; it means that you need to import a complete and full CSV containing ALL columns of a product ; the kind of CSV you can retrieve by performing an export.
The CSV you're trying to import is highly uncompleted ; it can't be imported due to the too many missing data.

Please use a CSV in a correct formating, using coma or semi colon as separator and using double quotes for string encapsulation.

So, you need to use a mass action.
www.hikashop.com/support/support/documen...massaction-form.html

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Time to create page: 0.067 seconds
Powered by Kunena Forum