Sales with product categories

Review the product category mapping functionality, its setup, and maintenance

🚧

This section provides instructions for a feature not enabled by default. Submit a request to Codat to activate the categorization mapping feature.

Product categories are used to track the types of items a merchant has been selling. For Codat’s Sync for Commerce clients, we support syncing product categorization data into a merchant’s accounting software.

This functionality is available for categorizing sales data and facilitates automated bookkeeping based on these categories.

Sales categories in the Sync Flow

Before the feature switch is toggled on, the Sync Flow UI displays a Sales category, along with Refund, Taxes, and Gratuity. These are standard available mapping categories of Sync for Commerce.

Sync Flow with standard sales categories

Sync Flow with standard sales categories

Once you enable the feature, an additional category mapping page is added to the Sync Flow. It replaces the Sales category with a breakdown of mapping options for each product category you created. We also provide a catch-all “Other sales” category that does not need to be created separately.

In this example, we break down sales into courses, products, and services.

Sync Flow with additional product categories

Sync Flow with additional product categories

The account mapping page for standard categories is available on the next page of the Sync Flow. It does not have a “Sales” mapping anymore, superseded by “Other sales” on the previous screen. The same categorization is also available in the Sync Flow settings.

Standard categories with sales categorization enabled

Standard categories with sales categorization enabled

Configure sales categories

Ensure the categorization mapping feature has been enabled for your client.

Then, create the product categories that you want to use for splitting sales data. To do so, use the /companies/{companyId}/data/commerce-productCategories endpoint with the PUT method.

For example, in order to create categories to break down sales into products, services, and courses, the following request body needs to be sent:

{
    "ContractVersion": "9.3.1",
    "ProductCategories": [
        {
            "id": "prods",
            "name": "Products"        
        },
         {
            "id": "serv",
            "name": "Services"         
        },
         {
            "id": "cours",
            "name": "Courses"        
        }
    ]
}

📘

Sync for Commerce does not support hierarchies of categories and requires a simple array of category IDs and names.

If you are using the visibleAccounts feature, ensure to add sales-accounts-sales-other to the list of visible accounts. This is to make “Other sales” mapping visible and configurable.

If you are using the visibleAccounts feature and some of your companies do not have product categories created, ensure to add sales-accounts-sales to the list of visible accounts.

Pitfalls

  • If you do not create any product categories after activating the feature, and then invoke the Sync Flow UI, the additional categorization page will not be displayed.
  • If you create, map, and subsequently delete a category, it will no longer appear in the Sync Flow UI. However, account mapping will still exist in the company configuration.
  • Once you introduce the product categories for a company, the previous Sales mapping will appear as “Other sales” mapping instead.

Customize category labels and text

To make a change in a product category label, amend the product categories using the /companies/{companyId}/data/commerce-productCategories endpoint, same as when you created them.

You can change the label for “Other sales” mapping using the configure-content-sales-accounts-entries-sales-other key.

The titles of the product categorization pages (named “Sales accounts” and “Other accounts” once the feature is toggled on) cannot be customized. The descriptions of the additional and existing account mapping pages cannot be customized separately.


Read next