Importing Custom Pricing (Options)

Before you begin, make sure the supplier and their products already exist in Xada. If not, refer to the related articles at the bottom of this page.

Once your supplier and products are set up, you can proceed with importing custom pricing.

Step 1 – Export the Options CSV

  1. Go to the Suppliers page.
  2. Filter by the supplier you want to update.
  3. Click the Options icon for that supplier (hover over icons to see their function).
  4. Click Export - the file will download automatically.

After downloading:

  • Delete all rows except the header row
  • This will serve as your clean template

Step 2 – Prepare the CSV

Populate the required fields as follows:

Core fields

  • ID: Leave blank when creating new options
  • Supplier: Ensure the supplier name is correct
  • SKU: Enter the correct product SKU
  • Currency: Set the currency (e.g. AUD)
  • Default: Set to Yes  or No
  • Active: Set to Yes  or No

Option details

  • Option – Type
    • Defines the option category (e.g. Unbranded)
  • Option – Original
    • The option name shown on your website
    • Use clear, unique descriptions
    • Example: Unbranded: All colours and sizes

Pricing fields

  • Setup Cost – Original: Enter any setup cost
  • Qty 1 – Original: Minimum order quantity (MOQ)
  • Price 1 – Original: Base price for the MOQ

You can define additional quantity breaks in subsequent columns for bulk pricing.

Extra fields

  • Positions: Available depending on your Xada subscription

Important:

  • Use the “New” columns only when updating existing options that originated from a data feed (e.g., Promodata). The Original columns must be retained, and your updates go into the New columns.
  • For options you are creating for the first time, use the Original columns since you are the originator.

Step 3 – Upload the Options CSV

  1. Save your completed CSV file
  2. Return to the same supplier’s Options page (as described in Step 1)
  3. Click Import
  4. Select your file

The import will begin automatically.

Important:

Do not refresh the page while the import is running, as this may interrupt the process.

Once complete, a confirmation message will be displayed.

Step 4 – Confirm the Import

To verify the import:

  1. Stay on the supplier’s Options page
  2. Filter by the product SKU you updated
  3. Confirm that the new option appears in the list

Related Articles