Back

Adding a New Product

This guide explains how to add a new product in the system, each field in the product form, and how to set a revenue account specific to the product so its sales are posted to it instead of the general sales account.

🛈

Before you start: Make sure the Inventory app is enabled in your account, and that your role includes the permission Add New Product.

How to Access

  1. From the main menu, click Inventory.
  2. Click Products & Services.
  3. Click the Add button, then choose New Product from the drop-down list.

Or open the page directly: Add Product.

Steps to Add a New Product

  1. Fill in the section Item Details: the name, description, category, and others.
  2. Fill in the section Pricing Details: the purchase price, selling price, and taxes.
  3. If the product is a stock product, enable Track Stock in the section Inventory Management and complete its data.
  4. Add any additional data in the section More Details:.
  5. Click Save.

You find each field explained in Fields Explained.

Fields Explained

Item Details

Field Description
Name The product’s name as it appears in the products list, invoices, and reports. A required field.
Item SKU The product’s code. It is generated automatically in sequence according to the auto numbering settings, and you can edit it.
Description A detailed description of the product.
Photos Upload one or more photos from your device, or drag and drop the photos in the upload area.
Category The product’s category, to make searching and reports easier.
Brand The product’s brand.
Sales Account The revenue account the product’s sales value is posted to. It appears only after enabling routing per product. See Setting the Revenue Account for the Product.
Sales Cost Account The account in which the product’s cost is recorded when it is sold. It appears with the Sales Account field when the Accounting app is enabled.
Unit Template The product’s units of measure, such as piece and carton. It appears when multiple units are enabled.
Supplier The product’s main supplier.
Barcode The product’s barcode. Click the circular arrows icon at the end of the field to generate a random number.
Available Online Shows the product in your online store. Requires enabling the Shop Front app.
Featured Item Shows the product in the featured products section of the shop front. Requires enabling the Shop Front app.

Pricing Details

Field Description
Purchase Price The product’s purchase price.
Selling Price The product’s selling price, written without the currency symbol.
Tax 1 and Tax 2 The taxes added to the product’s price in sales and purchase invoices.
Minimum Price The lowest price the product is allowed to be sold at. It appears when advanced pricing options are enabled.
Discount A fixed discount on the product, as a percentage or an amount. It appears when advanced pricing options are enabled.
Profit Margin A percentage added to the purchase price to calculate the selling price automatically. It appears when advanced pricing options are enabled.
Price Lists Add the product to one or more price lists with a different price for each list.

Inventory Management

Field Description
Track Stock Enable it so the system tracks the product’s quantities and inbound and outbound movements.
Initial Stock Level The product’s opening stock. It doesn’t appear when requisitions for purchases and sales are enabled or when a tracking type is chosen, and in this case the balance is recorded with a manual inbound requisition.
Low Stock Threshold The system sends an alert when the product’s quantity reaches this limit.
Tracking Type Serial Number, Lot Number, Expiry Date, Lot Number And Expiry Date, or Quantity Only. Requires enabling product tracking from the inventory settings.

More Details:

Field Description
Internal Notes Notes that don’t appear to the client.
Tags Words that help you group and search for products.
Status Active to deal with the product, or Suspended or Inactive to stop dealing with it and hide it.

Setting the Revenue Account (Sales Account) for the Product

The product’s own revenue account in the system is the Sales Account. When it is set, the product’s sales value in invoices is posted to this account instead of the general sales account. This field is hidden by default, and it appears after enabling routing per product.

Step One: Enabling Routing per Product

  1. Open the page Accounts Routing, the tab Sales: Product Sales Account.
  2. In Product Sales Account Routing Type choose Specify per Each.
  3. Click Save. The message Account routing has been saved.

🛈

Note: You need the permission Edit General Settings to open the Accounts Routing page. It is enough to do this step once for the whole account.

Step Two: Choosing the Account in the Product

  1. Open the product for editing, or add a new product.
  2. In the section Item Details, choose the required revenue account in the field Sales Account.
  3. Optionally, choose an account in Sales Cost Account to record the product’s cost in a specific account.
  4. Click Save.

  • Default: the product’s sales are posted to the general sales account.
  • Without Routing: no account is assigned to the product.
  • The chosen account must be a sub-account in the chart of accounts. If the revenue account doesn’t exist, create it first under Revenue.

Rules and Restrictions

  • Name A required field.
  • The barcode isn’t repeated for more than one product, and it isn’t less than 5 digits.
  • A unit template can’t be chosen for a product that has a tracking type.
  • The fields Sales Account and Sales Cost Account appear only after choosing Specify per Each in Accounts Routing.
  • Changing the sales account affects new invoices. The entries of previous invoices don’t change unless you edit the invoice and save it again.

Error Messages

Message Cause Solution
This barcode already used The barcode is registered for another product. Enter a different barcode, or generate a random number.
The barcode must be at least 5 digits long The barcode is shorter than 5 digits. Enter a barcode of 5 digits or more.
You can’t choose a unit template for a product that has a tracking type You chose a unit template and a tracking type together. Choose only one of them.
The unit factor is required for each item barcode You added a barcode for a unit without setting its factor. Enter the unit factor for each barcode.

The Effect on the System

Adding the product doesn’t create an entry by itself, unless you enter a quantity in Initial Stock Level, so its opening balance is recorded. The effect of the sales account appears when the product is sold. Example: selling a product for 1,000 without tax, with the account “Consulting Revenue” set as the sales account:

Account Debit Credit
Client account 1,000 —
Consulting Revenue (the sales account set for the product) — 1,000
Total 1,000 1,000

If the field is left on Default, the general sales account appears in place of “Consulting Revenue”.

Statuses and Settings

  • Minimum Price, Discount, and Profit Margin appear when Advanced Pricing Options are enabled in the inventory and products settings.
  • Available Online and Featured Item require enabling the Shop Front app.
  • Initial Stock Level disappears when requisitions for purchases and sales are enabled or when a tracking type is chosen.
  • Tracking Type requires enabling product tracking.
  • Sales Account and Sales Cost Account require choosing Specify per Each in Product Sales Account Routing Type.

Frequently Asked Questions

How do I set a revenue account specific to the product or service?

The revenue account is the Sales Account in the product or service form. Enable it first from the sales accounts routing by choosing Specify per Each in Product Sales Account Routing Type, then choose the account in the product. The details are in Setting the Revenue Account for the Product.

I can’t find the Sales Account field in the product form. Why?

Because routing per product isn’t enabled. The default value of Product Sales Account Routing Type is Without Routing. Change it to Specify per Each so the field appears.

Does the new sales account change the entries of previous invoices?

No. The account applies to invoices created after it is set. The entry of a previous invoice changes only if you edit it and save it again.

Can the sales account be set when importing products?

Yes. After choosing Specify per Each, the columns Sales Account and Sales Cost Account appear in the products import. If the account is incorrect, this message appears: “Wrong Sales Account in line number [line number], make sure to select existing sub-account”.

Why doesn’t the Initial Stock Level field appear?

Because requisitions for purchases and sales are enabled, or because you chose a tracking type for the product. In this case, record the balance with a manual inbound requisition.