Skip to main content

Shopify: Post Discounts by Product or Discount

When completing a journal entry mapping, we have categories and subcategories. Categories are required to be mapped, or else the journal entry will fail to post to your accounting software. See below for an example showing Gross Sales as the category and the subcategories beneath it:

Gross Sales and Subcategories

The subcategories can be located for a specific journal entry line by clicking the caret on the right, as shown below. If this caret is not present, it means this line does not have any subcategories:

Locate Subcategories

Optional Subcategory Mapping

The subcategories are optional to map. In the case of the Shopify Summary, we offer the discount title/code or the product category or product name from Shopify as subcategories for Discounts. This means you have the option to break down discounts by product category/name or discount title.

Creating Accounts with the Magic Wand

If you don't have accounts set up in your accounting platform, click on the "Magic Wand" button to the right, as shown below, which is visible per line. This will create an account in your accounting platform and map that line to this newly created account:

Magic Wand Button

Once this account is created and mapped, the discount will be posted to the account in your accounting platform to give you insight into performance.

Changing the Default Discount Posting Method

The default discount posting method for Shopify is by product type. However, if you would like to change this rollup to per discount title, visit the "Connections" page and "My Apps" tab. From here, locate the Shopify connection and click “Setup” to expand the connection options to then locate "Configure," as shown below in blue. When clicking "Configure," this will open a modal to change the "Discounts Rollup Method."

Configure Discounts Rollup Method

Below is the view with the Discounts Rollup Method option where you can select Product (default) or Discount, which will impact the subcategories for the discounts line as discussed above:

Discounts Rollup Method Options

note

When the discounts rollup method is set to Product, it will follow the product rollup method set for the Sales Rollup Method. That is, by either product category or item name. Below illustrates the options available: Sales Rollup Method Options

Here is an example posting with the discounts, broken down by Product type:

Discounts by Product Type

Alternatively, after changing the discounts rollup method, here is the same posting above, except the discounts are broken down by discount:

Discounts by Discount Title

As always, feel free to contact support@bookkeep.com if you have any questions.