Notes:
There are 2 different types of API keys in PF: admin and scoped. Admin key has access to more objects (including suppliers) and can "see" the whole organisation. Scoped key is specific to only that company´s objects and does not have access to suppliers. We had multiple requests from customers who had access to the admin key and wanted more from the integration. Please see more detailed information about this here.
Alternating from one type of key to another requires different data sets and configurations; therefore, any time this happens, we feel the best option is to start a new webshop/integration.
Mapping Information
Now we show the specifics of how we map data for each entity.
Products
Optiply | Picqer |
name | name (will be ““ if there is no name) |
skuCode | productcode |
articleCode | productcode |
price | price |
unlimited_stock | unlimitedstock [‘true' or 'false’] |
purchase_in_quantities_of | purchase_in_quantities_of |
stockOnHand | stock.freestock |
currentStockDate | now |
status | active [‘true' or 'false’] |
eanCode | barcode |
assembled | assembled [‘true' or 'false’] |
All products with the status "active" in Picqer are shown in Optiply. The products with the status "inactive" are not included in Optiply.
Products Compositions
Optiply reads the compositions of composed and virtual products from Picqer and uses these to provide ordering advice for the products you purchase.
The product has a key named type.
The value for this can be:
normal, unlimited_stock, virtual_composition, composition_with_stock
Here follows the mapping rules based on this:
Type | unlimited_stock | assembled |
normal | false | false |
unlimited_stock | true | false |
virtual_composition | false | true |
composition_with_stock | false | true (in this scenario also imports the webshop_product_compositions) |
Important note: IF unlimited_stock = true OR assembled = true, the product will not show on Optiply.
Remove products
Do you want to remove a product? First, give it the status "inactive" in Picqer. The product will then disappear from Optiply. You can then remove the product from Picqer.
Supplier information
Picqer Fulfilment does not have suppliers. You keep supplier information in Optiply. Tell us which suppliers you use, and we'll add them.
Supplier product information
Because Picqer fulfilment has no suppliers, you keep supplier product information with us.
Buy Orders
By default, we write the placed purchase orders from Optiply to Picqer fulfilment. If you do not want this, please let us know, and we will not send the orders to Picqer.
Purchase orders created in Picqer are synced to Optiply under "unknown supplier" because the supplier object does not exist in Picqer Fulfilment. Deliveries and stock changes will also synchronise.
Optiply | Picqer |
supplier | idsupplier - or extrapolated through supplier_name in the “no admin key mode”(see notes above) |
completed | IF status = ‘received' or ‘cancelled' → updated [date] (otherwise -> 'null’) |
placed | created [date] |
Buy orders are pulled nightly.
A buy order with one or more products still not received does not get the status “completed“.
In Optiply will remain without being completed (completed = null) [in this scenario customer can also close the order]
Buy Order Lines
Optiply | Picqer |
price |
|
quantity | amount |
subtotalvalue | amount * price (*) |
(*) The subtotal value is the multiplication of the amount by the price
Sell Orders
Optiply | Picqer |
status | status |
placed | created [date] |
completed | updated [date] |
totalValue | 0 |
IF the order has 0 (zero) order lines, it will not be imported
Sell Order Lines
Optiply | Picqer |
price | products.price |
quantity | products.amount |
subtotalvalue | amount * price (*) |
(*) The subtotal value is the multiplication of the amount by the price
Item Deliveries
Optiply | Picqer |
occurred | received date from receipt |
quantity | amount from receipt |