Jump to content

modify product price in backoffice when creating new command


Recommended Posts

I have a problem creating a new order in the backoffice when I want to change a price for a customer.

I can do a specific price on a product to a customer for a first order. But if I later create a new order for this client and change the price of the same product, it becomes impossible. The normal price is always redrawn.

 

I think it is a bug.

 

I found that creating a specific price for a customer generates backoffice database record specific price in the table with the identifiers ps_specific_price customer's product basket. Now there is a unique index on this table (id_product_2) that prevents the creation of a second new specific price (sql log mode, I get the message "Duplate key ...")

 

I think I have solved this bug by putting the index table id_product_2 ps_specific_price in nonunique. Suddenly, a specific price linked to customer, product, attribute, cart can be created.

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...