Pricing

Fabric's Pricing module allows you to set and track the monetary value of your products.

Offers Pricing

  • The product's regular selling price (e.g. MSRP)

  • The amount paid by the merchant for the product

  • The lowest price (strikethrough/markdown price) a product will be sold for. When populated, the Clearance Price takes precedence over Price on the commerce site; the customer will pay the Clearance Price. Promotions and Coupons do not apply to Clearance Price.

  • A modified price calculated by applying promotions to the product Price. When applicable, the Promotional Price takes precedence over Price on the commerce site; the customer will pay the Promotional Price.

  • The value separating the highest and lowest value among the Price, Clearance Price, and Promotional Price, calculated using all active or upcoming pricing instances for a product with/without variants. Price range for a Parent Product is calculated using all the active or upcoming pricing instances of all its Variants.

  • Date & time when product prices are active. The system defaults to the Offers customer's local time. If an end date is not set, the system defaults to Dec 31, 2099.

  • A product can have a different price at different intervals of time so, the price of a particular product can have the following statuses: 1. Current: Active price/clearance price/promotion price 2. Expired: Price is no longer in effect 3. Upcoming: Planned price/clearance price/promotion price as defined by a future start date & time

  • Similar products with a finite set of differing attributes (i.e. color and size). Products with variants can be organized together as "products with variants"

  • Pricing of product(s) for a certain interval

Instructions for adding and updating product pricing

Step 1: Navigate to the Price listing page and click on the Product you want to modify

Step 2: Populate Pricing details

  • Cost (optional) 
  • Price (mandatory) 
  • Clearance price (optional) 
  • Start date and time (mandatory), defaulted to current date and time, in local time zone
  • End date and time (mandatory), defaulted to Dec 31, 2099

Note: Cost, price, and clearance price can be setup/updated with up to 5 decimal places and in the pricing details table will show the number of decimal places entered by the user.

Step 3: Click Add price

Pricing product without variants
Pricing product without variants

 

You may add / edit pricing information for all product variants simultaneously.  You may also add / edit pricing for a single variant.

Step 1: Navigate to the Price listing page and click on the Product with variants you want to modify

Step 2: Populate Pricing details

  • Cost (optional) 
  • Price (mandatory) 
  • Clearance price (optional) 
  • Start date and time (mandatory), defaulted to current date and time, in local time zone
  • End date and time (mandatory), defaulted to Dec 31, 2099

Step 3: Click Save

Update all variants
Update all variants

 

You may add / edit pricing information for all product variants simultaneously.  You may also add / edit pricing for a single variant.

Step 1: Navigate to the Price listing page and click on the Product with variants you want to modify

Step 2: Click on the Variant you want to modify

Step 3: Populate Pricing details

  • Cost (optional) 
  • Price (mandatory) 
  • Clearance price (optional) 
  • Start date and time (mandatory), defaulted to current date and time, in local time zone
  • End date and time (mandatory), defaulted to Dec 31, 2099

Step 4: Click Add price

Follow instructions as above.  You will receive a warning.  Accept the warning to proceed

Overwrite warning
Overwrite warning

Promotional price is calculated by SKU, taking all eligible, available active promotions for the applicable promotional time frame into consideration. When multiple promotions are active and eligible, the promotion price is calculated using the best promotion (the one which gives the lowest SKU price).

 

For example:

Three promotions are active/scheduled.

TypeDiscountStart DateEnd Date
Individual SKU20%Oct 1, 2020Oct 30, 2020
Individual SKU$100Oct 1, 2020Nov 30, 2020
Individual SKU15%Oct 1, 2020Nov 30, 2020

 

On Oct 27, 2020, all of the promotions above are applicable to SKU XYZ.  The best available promotion is the 20% discount. Therefore, SKU XYZ's Promotional Price is calculated to be $800 (20% off $1000 price).

SKUPricePromo PriceStart DateEnd DateStatus
XYZ$1000$800Oct 1, 2020Oct 30, 2020Active
XYZ$1000 Oct 30, 2020Dec 30, 2099Upcoming

 

On Nov 5, 2020, the 20% discount promotion has expired.  Of the remaining two promotions, the 15% discount is the best available promotion.  Therefore, SKU XYZ's Promotional Price is calculated to be $850 (15% off $1000 price).

SKUPricePromo PriceStart DateEnd DateStatus
XYZ$1000$800Oct 1, 2020Oct 30, 2020Expired
XYZ$1000$850Oct 30, 2020Nov 30, 2020Current
XYZ$1000 Oct 30, 2020Dec 30, 2099Upcoming

 

Note: Offers does not calculate all upcoming Promotional Prices, only the current, best-available promotion is calculated in the Pricing module.  Past Promotional Prices are shown, along with applicable dates. 

When a percent-off/amount-off promotion is active and applicable to a SKU, pricing details cannot be updated until all active, eligible promotions are terminated or expired.  Pricing details can be updated for dates following promotion expiration.

 

For example:

Three promotions are active/scheduled and eligible for all SKUs.

TypeDiscountStart DateEnd Date
Individual SKU20%Oct 1, 2020Oct 30, 2020
Individual SKU$100Oct 1, 2020Nov 30, 2020
Individual SKU15%Oct 1, 2020Nov 30, 2020

 

On Oct 27, 2020, SKU XYZ's Promotional Price is $800 because the best-available 20%-off promotion is applied.  Pricing cannot be updated for SKU XYZ until Oct 30, 2020, when the 20%-off promotion expires.  Dates before Oct 30, 2020 will appear disabled in the pricing module and cannot be selected.

SKUPricePromo PriceStart DateEnd DateStatus
XYZ$1000$800Oct 1, 2020Oct 30, 2020Active
XYZ$1000 Oct 30, 2020Dec 30, 2099Upcoming

 

On Nov 5, 2020, SKU XYZ's Promotional Price is $850 because the best-available 15%-off promotion is applied.  Pricing cannot be updated for SKU XYZ until Nct 30, 2020, when the 15%-off promotion expires.  Dates before Nov 30, 2020 will appear disabled in the pricing module and cannot be selected.  The price can be scheduled for update following Nov 30, 2020, as below.

SKUPricePromo PriceStart DateEnd DateStatus
XYZ$1000$800Oct 1, 2020Oct 30, 2020Expired
XYZ$1000$850Oct 30, 2020Nov 30, 2020Current
XYZ$800 Dec 1, 2020Dec 30, 2099Upcoming

Adding/Updating prices for multiple products using a .csv upload

Step 1: Navigate to the Price listing page and click on Add Bulk Price in the upper right of the screen

Step 2: Select a file to upload

  • An import template is available for download via Offers
  • The template includes the following fields
    • SKU ID: Mandatory
    • Base Price: Mandatory
    • Sale Price: Optional
    • Price Type: 
    • Start Date: Mandatory; The start date and time must be in UTC as follows:
      • Date format for start date is YYYY-MM-DDTHH:MM:00.000Z
      • HH (hours) uses a 24 hour format
      • MM (minutes) format should be in 15 minute increments (00, 15, 30, and 45)
    • End Date: Optional; The default End date is Jan 01, 2100, 05:29 PM via bulk price upload

Step 3: Click Upload file

Note:

  • You can check the status of your file upload by clicking on the down arrow next to the Add bulk price button and selecting Import history
  • If there is an error in the file, only rows prior to the errored row will be uploaded.  When the upload is complete, you can download a CSV file with errors, adjust the errors, and upload the corrected file through the process above.

Bulk import
Bulk import

User can post prices of SKUs in bulk with their quantity ranges using Fabric API - price/bulk-insert

 

Curl location : https://prod01-apigw.XcustomernameX.fabric.zone/api-price/price/bulk-insert

 

Price in request body is unit price and Range in the request body is price for that quantity range. 

 

 

User can get prices of SKUs with their quantity ranges using Fabric API - v2/price/get

 

Curl location : https://prod01-apigw.XcustomernameX.fabric.zone/api-price/v2/price/get

 

New field "quantity" is added in the request so as to fetch the price of any SKU as per the requested quantity.

 

 

Fabric Offers promo validate api will now validate the prices as per their quantity - promo/validate

 

Curl location : https://prod01-apigw.XcustomernameX.fabric.zone/api-price/promo/validate

 

New field "quantity" is added in the request so as to fetch the price of any SKU as per the requested quantity to validate the coupon/promotion.

 

 

Last update: Jun 07, 2021

Have any questions?
Let's Talk.