Introduction
When working on integrations for customers, the use of price lists has often caused additional challenges. This is often because of the myriad of ways in which each client uses them, each in their own way. Think of different start and end dates, price list codes, needing the lowest price versus a custom price, etc.
To make this a bit more straightforward, Tinx has created a table and a report that allow clients to customize their pricing and ensure the correct price is synced between their database and webshop. Both are called TINX Price Container, the table having ID 11205351 and the report 11205301.
In the example below, item 100103 has multiple prices. In some cases, a different price for the same price list code. This would normally make it difficult to determine which price the connector needs to sync to the webshop.
After setting up and running the report, however, the price container table will show an overview where there is only one price per sales code, allowing for easier retrieval for the connector.
Setup
To set up this functionality, head to Setup > E-Commerce Integration Setup. There, scroll down to the 'B2B Regular Item Prices' tab. The settings in this tab will be used by the report to choose prices. Key here is the Price Priority setting, which determines which priority should be used when choosing a price:
-
Unit Price: filter on either the lowest or highest price.
-
Date Created: filter on the latest or earliest date created.
-
Start-End Date: filter on either the start date or the end date of a price list.
You can furthermore filter on the:
- Price List Code/ Assign-to No.
- Price Source Type, such as All Customers, Customer Price Group, Customer Disc. Group, Campaign, etc.
When the report is running correctly, you will see a flow field be updated on the Webshop Item Card of products: "No. Of Container Prices".
Clicking on this field opens up a filtered view of the price container table, with the different prices specific to that item.