Import Product Costs from a CSV or Excel File

If you have many products, filling in costs in a spreadsheet is faster than typing them one by one. Download a prefilled template, add your costs in Excel or Google Sheets, and upload the finished file.

Step 1: Download the Template#

On the Product Costs page, click the small arrow next to the Cost sync button and choose Download Template.

First choose which products to include:

Then pick a file format. CSV opens in any spreadsheet app; Excel (XLSX) is the native Excel format. Click Generate Template. The download starts automatically when the file is ready, and you can optionally have a download link sent to your email.

Step 2: Fill In Your Costs#

Open the file in your spreadsheet app. Each row is one product variant. The identifying columns are prefilled; you fill in the cost columns. Each row needs a variant_id or a sku so Profitario knows which variant it belongs to. The template has both; if you build the file yourself, the sku column alone is enough.

A filled-out file looks like this:

Step 3: Upload the File#

Back on the Product Costs page, open the same menu next to Cost sync and choose Import Costs, then click Next to reach the upload step. Drag your file into the upload area or click it to browse. CSV and XLSX files are accepted.

Profitario reads the file immediately and shows how many rows it parsed. If some rows have problems, a warning shows how many are affected; the remaining rows are still usable.

Below the row count, Match rows by decides which column identifies the variant:

Each option shows how many rows have that column filled, so you can see what a choice will skip. An option whose column is not in the file is greyed out.

If the upload is rejected, check for these causes.

• Missing required columns. The file must contain a variant_id or a sku column with the header spelled exactly as in the template. Keep the template's header row unchanged.
• Invalid numbers. unit_cost and handling_cost must be plain positive numbers. Remove currency symbols, thousands separators, and text like "n/a".
• Invalid currency. currency must be a three-letter code such as USD. Leave the cell empty to use your store currency.
• Too many broken rows. If more than half the rows fail validation, the whole file is rejected. This usually means a formatting problem affecting every row, such as the wrong delimiter or a shifted header.

Step 4: Check the Preview#

The Preview step lists every row with a status, so you can see exactly what will happen before anything is saved. The note at the top sums it up, e.g. "13 of 13 rows will be applied".

Skipped rows never block the import: you can apply the ready rows and fix the rest in a later upload.

Step 5: Apply the Costs#

Finally, choose how the imported costs affect your orders:

If your shop uses cost zones, the zone picker at the top of this step decides where the costs go. It is preselected to the zone tab you opened the wizard from; Default writes the shop-wide costs that every zone without its own cost inherits, a zone writes only that zone and leaves Default and the other zones unchanged. Upload one file per zone to import different costs per region.

Click Apply to Default (or Apply to the chosen zone). When the import finishes, you see how many costs were created or updated. Rows whose variant_id or sku matches nothing in your store are listed and skipped. Imported costs show a blue CSV badge in the Source column, and profit is recalculated for affected orders.

Preguntas frecuentes