This article covers how to import price lists (catalogs) via CSV.
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 B2B pricing use cases can be supported through these price lists.
Prices in Convictional require a bit of basic math. Here is how the math works:
- Base price is how much our sellers charge our buyers. Simple.
- Markup is how much to add to that base price to arrive at a "retail" price.
- Conversion is the difference in currency between base and markup.
If you are starting from retail prices, trying to figure out your B2B prices, here is how it works:
- If you take the markup out of your retail price, you should arrive at base price. For example: retail is $100, the wholesale/B2B price is $60. The markup would be $40.
- If you choose "percent" as the markup type, then the markup should be how much percent you want to add to the original price. For example:
Base price is $100. You want the retail price to be $250. The markup is then 150%.
- The conversion rate is applied to the resolved price (ie. base plus markup) in order to calculate the final retail price. Say you want to set your pricing worldwide in USD, but charge consumers in their local currency at retail. With Convictional you can, but you need a price list *per currency*.
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
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
Remember to leave empty spaces for optional fields so we can map each one
We currently accept CSV files only, Excel format have to be exported to CSV first
You can find a template for uploading pricing here. You can go to File > Make A Copy, and that will create an editable template. Alternatively you can go to File > Download to get a local copy.
Once you have filled out the template with the pricing, head over here to upload it. You'll notice any existing price lists you have as well as a button for uploading the list you prepared:
Click `Upload` and you'll be prompted to select your price list from the files on your computer
The next step would be to add a partner. If your partners are already added, you would have to assign your partner your new price list. Here's how you invite a partner.