Customer specific prices
Last updated
Was this helpful?
Last updated
Was this helpful?
You can easily provide new custom prices manually via Shopware admin area.
You can easily create new custom prices via Shopware Admin API (Shopware Standard).
Or ... just use the "admin-api/sync-api" of shopware for batch-process.
Entity: b2b_customer_price
We know that a lot of ERP vendors or interface providers still provide data using traditional methods. For example, also via an SQL insert. For this reason we have provided you with two optional fields: customer_number and product_number.
You can fill these two fields and leave the customer_id + product_id fields (which require a UUID) blank.
Then you can use our provided command to convert customer_number's and product_number's to uuids.
You can also fill the customer_id and product_id directly if you have the data available.
You should know that if a customer individual price is stored, this is drawn last and is therefore the last level of the price calculation. Even if you have stored a customer discount rate (addon), this is not taken into account and overwritten by the customer-specific price.
A big advantage of our custom prices is the possibility of full scale pricing, even in combination with Shopware standard prices. Thus, even such a configuration is possible:
1-5 pieces - Shopware calculated price via extended prices
6-15 pieces - customer individual price
16-30 pieces - Shopware calculated price via extended prices
from 31 pieces - ccustomer individual price
Basically, all sizes of customer individual prices can be covered! In our Highlast-Demoshop more than 3 million customer individual prices are maintained. Our approach in the background is designed for large amounts of data.
You can specify a validity of individual customer prices. Period of validity from/until. This means that a custom price is valid only in this period.
Attention, you have to set in B2Bsellers Suite -> CORE plugin configuration that the validity period should be respected. (This setting is necessary for performance reasons)
Use the following command to remove the prices that are no longer valid from the database:
Since there is only one price here, the complete price is exceeded and a label is added so that the customer knows that this is a special arrangement.
Endpoint: POST json
Here you'll find more informations about the sync-api (bulk / batch payload)
More information:
