Every item you sell through Acenda has a base price, and you can add a custom price for any sales channel that should sell it at a different price. This article shows how to set both, one item at a time or in bulk with a spreadsheet.
Use the item's Pricing tab for quick, one-off changes. Use an import when you need to update many items at once.
Before you start
Prices are set on items, not groups: The Pricing tab only appears on items whose Group is variant (item). A product (group) has no pricing of its own. Open each of its variants to price them.
Base price: The default price, sent to every sales channel that doesn't have a custom price for that item.
Custom price: A channel-specific price linked to that channel's Subscription ID. You can find your Subscription IDs in the sidebar under CHANNELS > Integrations.
Tip: A custom price always wins for its channel. Once an item has a custom price for a channel, changing the base price won't change the price on that channel.
Update prices for a single item
In the sidebar, under CATALOG, click Items.
Find the item (searching by SKU is quickest) and click the eye icon to open it.
Click the Pricing tab.
To set a base price for the first time: In the Set base price form, enter the Price, and optionally the MSRP and MAPP, then click Update. Add an MSRP if you plan to run promotions (see How to Set Up Price Promotions).
To change the base price: In the price table, click the Base row, edit Price, MSRP or MAPP, and click Update.
To add a custom channel price: Click Add custom price, choose the channel in the Subscription list (its Subscription ID is shown next to the name), enter the Price and optionally the MSRP and MAPP, and click Add.
To change or remove a custom price: Click its row in the price table. Edit the values and click Update, or click Delete to remove it so the channel goes back to the base price.
Important: We recommend managing MAPP (Minimum Advertised Price) on the base price only. Setting different MAPP values on custom channel prices can lead to conflicting pricing rules.
Each channel can have one custom price per item. When every channel already has one, the Pricing tab shows There are no available subscriptions. Edit the existing custom price instead.
Update base prices in bulk (Catalog import)
Use a Catalog import to change base prices for many items at once. For a full walkthrough of the import screen, see Using the Import Feature: How to Import Product Data into Acenda.
Step 1: Prepare your file
Create a spreadsheet with these three column headers, exactly as shown:
Header | What to enter | Example |
sku | The item's SKU, exactly as it appears in Acenda. | YOUR-SKU-123 |
pricing_item.price.amount | The new base price. | 24.99 |
pricing_item.msrp.amount | The new MSRP (optional, but needed for promotions). | 29.99 |
Save the file as .xlsx or as a UTF-8 CSV. Older .xls files aren't accepted. See How do I save my import file as a CSV in UTF-8 format?.
Only the first sheet of a workbook is imported.
Include only the items you want to change, and put a price on every row.
Step 2: Import the file
In the sidebar, under DATA TRANSFERS, click Imports, then click New Import.
Set Import Type to Catalog and upload your file.
Check the preview to make sure each column is mapped to the right field.
Under Import options, keep Overwrite any current records that have the same ID checked. We also recommend checking Only update existing records, so a mistyped SKU is skipped instead of creating a new item.
Click Start Import. When it finishes, spot-check a few items on their Pricing tab.
Set channel prices in bulk (Custom Pricing import)
Use a Custom Pricing import to set a different price for each sales channel, for example a higher price on a marketplace that charges higher fees.
Step 1: Export your current custom prices
In the sidebar, under DATA TRANSFERS, click Exports.
Set Export Type to Custom Pricing and choose a Format.
Click Export next to the export profile you want to use.
When the file appears under Generated Files, download it.
If you don't have any custom prices yet, the export will be empty. Create a spreadsheet with the columns in Step 2 instead. For more on exports, see Using the Export Feature: How to Export Data from Acenda.
Step 2: Prepare the file
Delete the five record-history columns at the start of the export: id, created_at, created_by, updated_at and updated_by. Acenda matches each row by SKU and Subscription ID, so you don't need them.
Keep these columns: sku, subscription_id, price.amount, price.currency, msrp.amount, msrp.currency, mapp.amount and mapp.currency.
Fill in sku, subscription_id and price.amount on every row. Set the currency columns to USD.
Use one row per item per channel. For example, YOUR-SKU-123 priced for two channels needs two rows.
Save the file as .xlsx or as a UTF-8 CSV (see How do I save my import file as a CSV in UTF-8 format?).
Tip: An item needs a base price before you can give it a custom price. Set base prices first, then import your custom prices.
Step 3: Import the file
In the sidebar, under DATA TRANSFERS, click Imports, then click New Import.
Set Import Type to Custom Pricing, upload your file and check the preview.
Keep Overwrite any current records that have the same ID checked. If it's unchecked, rows for items that already have a custom price on that channel will fail.
Click Start Import.
How long changes take to reach your channels
Price changes are saved in Acenda as soon as you click Update or the import finishes. Each sales channel then picks them up on its own schedule. Some update within minutes, while others can take several hours or until the next day.
Prices are only sent for items that are mapped and listed on that channel.
Troubleshooting
No Pricing tab, or the pricing options are missing: The item is probably a product (group). Prices are set on each variant (item), so open the item's Variants tab and price each variant.
The new price isn't showing on a channel: Check whether the item has a custom price for that channel, because it overrides the base price. If a price promotion is running on that channel, shoppers see the promotion price until it ends. Also make sure the item is mapped and listed on that channel, and allow time for the channel's update cycle.
The price went to the wrong channel: Check the subscription_id against CHANNELS > Integrations. Acenda doesn't check this ID against your channels during import, so a wrong ID can save a price that no channel uses. Fix the ID and import again, then delete the stray price on the item's Pricing tab.
"price.amount is required": The row's price is blank or 0. Enter a price greater than zero.
"subscription_id is required" or "pricing_item_id or sku is required": The row is missing its Subscription ID or SKU.
"no pricing_item found": The item has no base price yet, or the SKU doesn't match an item. Check the SKU, set a base price, then import again.
The file won't upload, or some rows are missing: Save it as .xlsx or UTF-8 CSV (not .xls) and make sure all your data is on the first sheet.
To see why rows failed, open DATA TRANSFERS > Imports and click the red View Errors icon next to the import to open its Error Log.
Related articles
Still stuck? Contact Acenda Support and tell us the SKU and the sales channel involved.
Keywords
update price, change price, pricing, base price, custom price, channel price, per-channel price, bulk price update, price import, price upload, price spreadsheet, MSRP, MAP, MAPP, Set base price, Custom Pricing import, Catalog import, Subscription ID, price on items not groups, variant price, group price, reprice