The Add Bulk Price feature allows you to upload a CSV file with details such as cost, price, and clearance price. This streamlined process eliminates the need for manual data entry, reduces errors, and saves time.

CSV File Guidelines

fabric doesn’t support any other data or file formats. Here are the key points to consider:

  • The headers, represented in the first row of the CSV file, should match the product details.
  • Empty rows and columns are ignored. Ensure that fields don’t contain blank spaces, returns, line breaks, or other characters not supported in the CSV.
  • fabric provides a CSV template file. Not following the parameters in the template can result in errors when uploading.

Product Price Data Formatting

When preparing a CSV file for import, ensure that the product pricing data format aligns with the following column requirements:

HeaderDescription
SKU IDThe SKU ID of the item in Product Catalog.
Cost OptionalThe cost of the item set by the distributor.
PriceThe price set in fabric to charge buyers for their purchases.
Clearance Price OptionalThe lowest price set in fabric to charge customers for their purchases.
Start DateThe 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, 2025 at noon would be 2025-06-01T12:00:00.000Z.
Price List NameThe name assigned to a price list when created.

Below is a sample of a valid CSV file for bulk price import:

SKU IDCostPriceClearance PriceStart Date (UTC)Price List Name
SOME_SKU_ID1112025-12-15T02:05:46.000ZDefault_PriceList_Name

Prerequisites

  • Ensure that you have the Offers Editor, or Administrator privileges to fabric Offers. For more detailed information on these settings, see the Role-Based Access Control section.

Procedure

  1. In the left menu, click Offers.
    The Products Pricing page is displayed.
  2. Click Add Bulk Price.
    The Import price CSV file window is displayed.
  3. Download the sample template by clicking Template: Price.
  4. In the Import price CSV file window, do one of the following:
    • Drag and drop your file to the window.
    • Click Select a File from your computer and select your file.
  5. Click Import File.

The CSV file is imported, and the prices are added to your products.