Set and track the price of your products

Offers works in conjunction with the products you have uploaded into your fabric PIM account. Offers automatically connects to PIM and displays all of the products you have uploaded. 

The Add Bulk Price button at the top-right allows you to upload a .CSV file with information including the cost, price, and clearance price. Clicking the button opens the Import .CSV file modal. It is highly recommended that you download the template as a guide. Not following the parameters in the guide will result in errors. 

Any .CSV file you upload must match the following headers and format:

  • SKU ID - the SKU ID of the item in PIM
  • Cost - the cost of the item from the distributor
  • Price - the regular amount you charge customers to purchase the item
  • Clearance Price - the lowest amount you charge customers to purchase the item
  • Start Date - the date the price change begins. Dates must follow the YYYY-MM-DDTHH:MM:00.000Z format. For example, a price change scheduled for June 1, 2022 at noon would be 2022-06-01T12:00:00.000Z.
  • Price List Name - the name you assign to the price list

You can check the status of your upload by clicking Import history. If there is an error in the file, Offers will flag the row with the error. When the upload is complete, you can download the .CSV file with the errors, correct them, and re-upload the file. Common errors include:

  • SKU ID not found - A SKU ID in the .CSV you uploaded does not match the SKU of any productin your PIM.

  • Headers are not matching with price template headers - The headers in the SKU ID you uploaded do not match the headers in the template. 

  • Only numeric and decimal values are allowed in Cost - There is a character in the Cost column of the .CSV you uploaded that isn’t a number or decimal.

  • Incorrect date format for Start/End Date (UTC). Use this date format YYYY-MM-DDTHH:MM:00.000Z - There are dates in the .CSV you uploaded that don’t match the correct format.

Pricing - add bulk price
Pricing - add bulk price

To set up the cost, price, or clearance price of an individual item, click on the dropdown menu to select the price list, click on the product you want to modify, and then edit the pricing details:

  • Cost - optional
  • Price - the regular amount you charge customers to purchase the item
  • Clearance Price - optional
  • Start date and time - the date the cost/price/clearance price begins. Dates must follow the YYYY-MM-DDTHH:MM:00.000Z format. For example, if a price began on June 1, 2022 at noon, you would enter 2022-06-01T12:00:00.000Z.
  • End date and time - same logic as Start date and time; defaults to December 31, 2099. 

Offers supports up to five decimal places for price, cost, and clearance price values.

To bulk edit the cost and price attributes for all the different variations of a product (e.g., all colors, prints, sizes, etc.) edit the parent product. To change only the cost and price attributes for a single product (e.g., only the green jacket), find and edit the individual variant.

Pricing - manual price editing
Pricing - manual price editing

Use the List View and Tile View buttons at the top-right of the page to change how the Pricing home page displays items. Tile View includes images but has less information, while List View has more information but no images.

Pricing - view mode
Pricing - view mode

Last update: May 10, 2022

Have any questions?
Let's Talk.