Importing Prices

This article covers how to import price lists (catalogs) via CSV.

Introduction

Pricing in Convictional is driven by price lists. Price lists also determined what products a given partner of yours is able to view and purchase. So consider our price lists part pricing and part catalog. When you setup a price list, we need to understand how to mark it up or down, what currency it’s in and the SKU specific discounts. Almost all wholesale pricing use cases can be supported through these price lists.

Importing CSV

To import pricing via CSV, please use the following format:

List Name, Currency, Conversion Rate, Rounding, Sku, SKU Cost, SKU Markup, Markup Type, Min Units (Quantity Break)

ie. Price List,USD,1.2,99,54321,9.99,5,fixed,10

Elements (Index)

  • Price List Name (0): A descriptive name for the price list (‘price list’)

  • Currency (1): currency of the shop(s) you want to sync with. (‘CAD’)

  • Conversion Rate (2) percentage markup (‘200’ = prices x 2)

  • Rounding (3): last two digits you want prices rounded up to (‘99’ = $1.99)

  • Sku (4): A variant-specific SKU (‘ABC-123’)

  • Base Price (5): base price for that SKU (‘9.99’)

  • Markup (Amount) (6): in percent (ie. ‘120’) or dollars (‘5’)

  • Markup Type (7): ‘fixed’ for dollar markup or ‘percent’ for percentage

  • Quantity Break (8): the number of units ordered for this discount to apply. Default: 1

Requirements

  • If the upload fails, check the format or ask support to review the file.

  • The file type must be CSV, Excel is not allowed.

  • Leave empty spaces for empty or optional fields (ie. “,”)

Example

You can find a template for uploading pricing here.