Importing Records

Importing from CSV or XML 

Packing Partner can import sales from other sources using CSV, Tab or Tilde delimited files.

After you have created the template as described below, in the Browser Tab, click Import on the toolbar. After the file has been read, and checked for errors, you can confirm the records you want to import.

The format (CSV, Tab, Tilde, XML) of the import file is determined automatically by Packing Partner, when it is imported.

Options and default settings

Default settings for imported records can be changed from Tools>Options>Settings>Importing .

Creating a CSV Template

To edit the import template go to Tools>Options>Records>Edit CSV Import , then open the CSV file in a spreadsheet and insert a row at the top.

Insert the corresponding data fields for each column, using {Unused}  or {Un} for any columns that aren't used. Then copy the top row of the spreadsheet and paste it into the CSV import editor.

If you need to amend the template you can cut and paste the text back into the top row of the spreadsheet.

Record fields

The fields in bold are mandatory


The identifier of the buyer (or buyer name if there is no separate ID)


Any notes from the buyer


Channel that the records have been collected from


Original sale date (tax point date) and the date it was paid


The reference for the sale


The URL of the orifinal sale. 


The name of the seller


Any notes added to the sale by the seller


The method chosen by the buyer or default shipping method


For multi-channel imports, this is the original marketplace, e.g. Amazon, eBay. 

{Unused} / {Un}

Denotes an unused column that exists in the CSV file but is not imported

Invoice fields



Carriage cost


Any charge that applies to the whole invoice and the name of the charge


The three letter abbreviation for the currency e.g. GBP, EUR


Any discount that applies to the whole invoice and name of the discount


Payment type, payment reference and URL to the payment processor's page


Tax rate as a percentage e.g 20


Invoice total 



Invoice weight in Kilograms or Grams 


Marketplace IOSS Number and taxed value

 Customer fields



Customer name and company fields


Customer address lines, {CusIso} is the two letter ISO code for a country, e.g. UK


CusScore is for a buyer rating supported on the import channel.
CusNotes is for specific customer notes. For notes about the order, use BuyerNotes1 or BuyerNotes2

Delivery fields



Delivery name and company fields




Delivery address lines, DelIso is the two letter ISO code for a country, e.g. UK


DelScore is for a buyer rating supported on the import channel.
DelNotes is for specific delivery notes. For notes about the order, use BuyerNotes1 or BuyerNotes2

Item fields 


Item Category, Condition, Comment, Gift message and Gift option


Item image Url, Title, Url and Variation


Item Quantity, Charge, Cost, Discount, Tax rate, Tax value and Total


Item code, Location and SKU


Item Weight and Dimensions, use either Kgs or Gms, not both