Product Prices
| File Prefix | PRODUCT-PRICES |
| Current Version | V2 |
| Attribute | Format | Length | Required | Description | Example |
| product_ref | Alphanumeric | 1-255 | Yes | Unique product reference descriptor | 103495 |
| sku | Alphanumeric. Use * as wildcard to indicate all skus | 1-255 | Yes | SKU of product variant | B01N53LF |
| price | Numeric | 1-255 | Yes | Product unit price | 399.99 |
| currency_code | ISO 4217 Must belong to our supported currencies | 3 | Yes | Currency code | USD |
| store_refs | Alphanumeric ; separated list. | 1-65535 | No | Price only applies to these stores. If omitted, apply to all stores. | B32;C85 |
| starting_on | Date ISO 8601 | 10 | No | Price applicable since | 2022-01-23 |
| ending_on | Date ISO 8601 | 10 | No | Price applicable until. Only valid for discounted prices | 2022-12-31 |
| discounted | Boolean [TRUE|FALSE] | No | Price represent a discount. If empty, defaults to FALSE | TRUE |
Standard price
A standard price will be applied as soon as it is received, considering there is no starting_on date or a date in the past. It has discounted as FALSE. If a new standard price is received, it will immediately replace the current standard price.
Scheduling a standard price
There is the possibility of setting a price to be applied on a future date. For example, in order to schedule standard price from the specified date 20XX-12-24, the CSV row with such standard price needs to be set as starting_on: "20XX-12-24". This price will be applied automatically at 20XX-12-24 and will remain applied until a new standard price is imported.
Discounted price
A discounted price is different in a way that the price will appear differently in BSPK, showing the standard and discounted price together, making the discount evident in the product page. In order to import a discounted price, the discounted attribute needs to be set to TRUE.
For a discounted price to be applied, a standard price must also or already be set for a given product. Just like the standard price, the discount price can also be specified for particular currency code, SKU or store of given product.
Both standard and discounted price can be sent in the same import file. In order to reset the discounted price, a new standard price needs to be imported for that product. Current discounted price can also be overwritten with a new discounted price whenever a new discounted price is imported.
Scheduling a discounted price
There is the possibility of scheduling a discounted price for the future. There is also the possibility of setting an ending_on date for that discounted price. If no end date is set, the discounted price will remain until a new price is applied.
As an example, lets suppose there is a sale for the upcoming holiday, that will start on Dec 24 and end on Jan 02. A price is sent with discounted TRUE, starting_on Dec 24 and ending_on Jan 02. This way, once Dec 24 starts, the discounted price will be applied, and once Jan 03 hits, the price is reverted back to its standard one.