Jump to content

Error in duplicating products


Recommended Posts

Someone know how to fix this problem in 1.6.1.3 ????? What is the fix exactly ?

Thanks

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Hi,

When I try to copy (duplicate) a product which has an assigned specific price (does not mater if it is on catalogue rules or specific prices on product prices tab) and added attrubutes combinations it generates error:

Duplicate entry '15-0-0-0-2017-10-12 00:00:00-2017-10-31 00:00:00-1-0-0-0-0-1-1' for key 'id_product_2'<br /><br /><pre>INSERT INTO `ps_specific_price` (`id_shop_group`, `id_shop`, `id_cart`, `id_product`, `id_product_attribute`, `id_currency`, `id_specific_price_rule`, `id_country`, `id_group`, `id_customer`, `price`, `from_quantity`, `reduction`, `reduction_tax`, `reduction_type`, `from`, `to`) VALUES ('0', '1', '0', '15', '0', '0', '1', '0', '0', '0', '-1', '1', '12', '0', 'amount', '2017-10-12 00:00:00', '2017-10-31 00:00:00')</pre>

It also does not copy product photos.

How to reproduce this error:
1. Add a new catalog rule with % discount (or create specific price with % discount on product prices tab - same result)
2. Add a product combinations in product's tab
3. Add a specific price in products's tab
4. Clone product
5. Debug mode is enabled

Thank you for help.
Regards.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...