Importing Sales Account and Sales Cost Account for Products
The product import and export file now includes the Sales Account and Sales Cost Account columns, so you can set Accounts Routing for hundreds of products at once instead of setting each product individually. This works for both adding and updating products.
Required PermissionsThe permission to import and add products, and Apply Accounting enabled.
How to AccessProducts > Import (Import Products)
Article Contents
Condition for the Two Columns to Appear
- The Routing Type of Product Sales Account must be Specify per Each in Accounts Routing (Sales section).
- If it is set to Without Routing, the two columns do not appear in the column validation, the example file, or the export.
- A special example file that contains the two columns is available when the condition is met.
- Location of the two columns: after the Taxes columns and immediately before Category.
Accepted Cell Values
| Value | Result |
|---|---|
| Account Number (Code) | The account with that number is linked |
| The exact Account Name | It is linked if no two accounts have the same name |
| “Number – Name” as exported by the system | It is linked by the number |
| Empty cell | The product’s current account stays unchanged |
| – (a dash only) | The account set for the product is deleted |
🛈
Note: The account must be a visible Sub-Account that is not on hold. A Main Account, a hidden account, an account on hold, or a name shared by more than one account is treated as an error.
When Updating Existing Products
- The values in the file replace the product’s current accounts.
- The two columns are not fields used to match products for the update.
Export
- The two columns are exported in the “Number – Name” format, so you can re-import the file as it is.
Quick Steps
- Set Product Sales Account to Specify per Each in Accounts Routing.
- Open Import Products and download the example file.
- Fill in the two columns, then upload the file and match the columns.
- Review the results list.
What Happens After the Import?
- The Sales Account and the Sales Cost Account are saved for each product, just as in the Edit Product screen.
- New Sales Invoices for these products are posted to the specified accounts.
- Previous Invoices do not change.
- A row with an error is not created, its product is not updated, and none of its accounts are partially saved.
Why Isn’t It Working as I Expect?
| Problem | Reason | Solution |
|---|---|---|
| The two columns are missing | The routing is not Specify per Each | Change it |
| An error message appears even though the name is correct | The name is duplicated, or the account is hidden or on hold | Use the number |
| The account did not change | The cell is empty | Enter the value |
| The account was deleted | The cell contains – | Enter the account |
Error Messages and Solutions
| Message | Reason | Solution |
|---|---|---|
| The Sales Account is invalid in row number %s. Please make sure you select an existing Sub-Account. | A value that does not exist, or a Main Account, hidden account, account on hold, or duplicated name. | Use the number of an active Sub-Account. |
| The Sales Cost Account is invalid in row number %s. Please make sure you select an existing Sub-Account. | The same reasons, for the Cost of Sales column. | Correct the cell. |
| To use the delete symbol, the dash (-) must be the only character in the cell | You entered a dash together with other text. | Enter – on its own. |
Frequently Asked Questions
Does the whole file fail if I make a mistake in one account?
No, only that row fails, and the product in it is not created or updated.
Why don’t I see the two columns?
The Routing Type is not Specify per Each, or Apply Accounting is not enabled.
How do I remove a product’s account through the import?
Enter – in the cell.
Does an empty cell clear the account?
No, you leave it as it is.
Does the name accept any language?
The name is accepted exactly as it is recorded in the Chart of Accounts.