Product Setup & Overview
This article helps Webgility Online users configure Product Settings to ensure accurate product mapping between their sales channels and QuickBooks Online. Proper product mapping is essential for successful order posting and error-free inventory tracking. The Product Settings section in Webgility Online allows users to define how products from sales channels are matched with products in QuickBooks Online.
Overview:
Product Settings is where you define how Webgility Online matches products between your sales channel and QuickBooks Online. You do this by linking the Product SKU from your sales channel to the Item Name in QuickBooks Online.
Note: You can also choose to match SKU to SKU directly if your sales channel and QuickBooks use the same SKU structure.
This screen also controls how Webgility Online will respond when a product from your sales channel does not automatically match an item in QuickBooks Online. In the interface, this behavior is highlighted in red for easy identification.
The recommended option is to map the product manually to the correct item in QuickBooks Online. When this setting is enabled, Webgility will prompt you to select or create the correct product at the time the order is posted, helping ensure your data stays accurate and organized.
Steps:
Go to Sync Settings > Products
-
Select which field should be used to identify and match Products from your Sales Channel and QuickBooks: You can match the SKU# of the Sales Channel with the QuickBooks Online Product Name (You may also match SKU to SKU).
-
The second condition is” If a matching product is not found, then”, you have four options here:
Select which field should be used to identify and match Products from your Sales Channel and QuickBooks: You can match the SKU# of the Sales Channel with the QuickBooks Online Product Name (You may also match SKU to SKU).
The second condition is” If a matching product is not found, then”, you have four options here:
-
Create a New Item in QuickBooks
-
Flag the order with an error
-
Use standard items instead
-
Give an option to Map it manually
- Create a New Item in QuickBooks (Inventory): This option will allow you to create the item (Inventory type) if not found while posting the orders into QuickBooks, it will also ask you to configure other settings required to create an inventory type of item.
-
Create new QuickBooks items as this type
-
Set the inventory start date as
-
Manually specify Inventory Start Date
-
Use this Inventory Asset account
-
Use this Income account
-
Use this Expense account
-
Set the Sales Description of the Item as
-
Set the new Item to be Taxable
-
Set the Item Quantity as
-
Use secondary item matching criteria if the primary is found blank on your sales channel
-
Update inactive Items and make them Active when posting Orders
-
Create a New Item in QuickBooks (Non-Inventory): This option will allow you to create the item (non-inventory type) if not found while posting the orders into QuickBooks, it will also ask you to configure additional settings as well that are required to create a non-inventory type item.
-
Use this Income account
-
Set the Sales Description of the Item as
-
Set the new Item to be Taxable
-
Use secondary item matching criteria if the primary is found blank on your sales channel
-
Update inactive Items and make them Active when posting Orders
-
Flag the order with an error: If this option is selected then while posting an order if an item on the order is not found in QuickBooks Online then Webgility Online will flag that order as errored and move it to the Errors tab.
-
Use a standard item instead: Once this is enabled it will ask you to configure an item from QuickBooks Online, once done then while posting orders if an item is not found then Webgility Online will use this standard item instead.
-
Given the option to Map it manually: This feature will prompt you everytime to perform mapping of the item if not found in QuickBooks Online while posting the order. This option helps you to configure the item mapping simultaneously with order posting.
There is another section by the name “Create New Product” at the very bottom, this configuration is used when the user of Webgility Online directly wants to create missing items (Inventory/Non-Inventory) into QuickBooks Online from the Products page instead and does not want to wait for any order posting.
-
Inventory
-
Income account
-
Inventory asset account
-
Expense account
-
Set inventory start date as
-
Override available date information from the Sales Channel
-
Set sales description as
-
Set purchase description as
-
Taxable
-
Set item quantity as
-
Non-Inventory
-
Income account
-
Expense account
-
Set sales description as
-
Set purchase description as
-
Taxable