Export PrestaShop Products to QuickBooks Online

Export PrestaShop Products to QuickBooks Online

By exporting products from the PrestaShop store, business owners can ensure that their product sales, expenses, and other financial transactions are accurately recorded in QuickBooks reducing manual data entry and the risk of errors associated with it, keep their inventory records up-to-date, make informed decisions about restocking and managing their catalog etc. As you might have guessed, in this article, we’ll describe how to carry out PrestaShop products to QuickBooks Online accounting. To start working with QuickBooks Online Integration available in Store Manager for PrestaShop, open an addon and authorize adding a new account.

QuickBooks Online Addon in PrestaShop Store Manager

Once you are done with a login, you’ll be transferred to the next page that displays future configurations list and products assigned to them.

Step 1. Create Configuration

The window on the left side of the addon allows creating and deleting configuration(s). Hit “New Configuration” for the start.

New Configuration for PrestaShop Product Export to QuickBooks Online

Step 2. Specify Product Export Configuration Settings

PrestaShop Product Export Configuration Settings for QuickBooks Online

At this step you can specify the Configuration name, save it for next exports and download it from the file.

Next, select the needed Export Method among the existing ones from the drop-down list:

Export Method for PrestaShop Product Export to QuickBooks Online

  • “Create and Modify” – once the export is complete, the new items will be created and added to the available product list on QuickBooks Online and the existing products will be updated.

  • “Create Only” – this method allows creating new items in QuickBooks without updating the existing ones.

  • “Modify Only” – only the existing products will be modified without creating new records.

Map Fields block contains the basic data related to product mapping:

Mapping Fields Step of PrestaShop Product Export to QuickBooks

“Item type” dropdown allows specifying the type of items that will be applied to the exported products on QB Online: inventory, non-inventory or service.

“Item name” – choose product name or SKU field for mapping during export.

“Item SKU” – select an identifier which will be used to identify the store products: Product Name, Product ID or SKU.

“Item sales description” – define which field will be used as the product description during sales: SKU, Product Name, Short Description or Description.

Item Accounts block consists of the accounts which are uploaded automatically, depending on the QuickBooks user’s settings.

Each account field has a dropdown list with the variants. If the fields are empty – you can retrieve them with the buttons on the right.

Item Accounts Settings for PrestaShop Product Export to QuickBooks

“Inventory asset account” shows the current value of the inventory: property insurance, rental insurance, interest paid, business loan interest, credit card interest, mortgage interest, inventory, inventory asset.

“Income account” records the profit from the sale of the items: HSA contribution, prepaid expenses, purchases, refunds to customers, repairs & maintenance, retained earnings, sales, sales of product income.

“Expense account” is used to pay the vendor for the items: building & property rent, buildings, business licenses, cash, commissions & fees, contract labor, contributions to charities, cost of goods sold.

The ‘Verify and Save’ button checks if required details are set up correctly and saves the configuration.

Step 3: Adding PrestaShop Products to Listing

Once the configuration is saved successfully you’ll have a possibility to add the products to it in the initial window on the right.

Adding PrestaShop Products to Export Configuration for QuickBooks Online

After that a separate window with category tree will be opened where you’ll need to select categories with products. Hit “OK” for further product export. You can also delete items from the list if needed.

PrestaShop Category Tree for Product Export to QuickBooks Online

After everything’s ready with the products, click on the ‘Process’ button for export. The export results will be shown in the progress bar.

Finish of PrestaShop Product Export to QuickBooks Online

Once the export is finished, click ‘Close’ to complete the process and exit the addon.

Benefit from Store Manager convenient opportunity to export PrestaShop products to QuickBooks Online Try Free Now!

Related Articles:

Card image
Work with QuickBooks Using PrestaShop QuickBooks Integration Addon

Rapidly sync data between PrestaShop and QuickBooks, fulfilling product export, customer export, order export, product import from QuickBooks. Read More…

Card image
PrestaShop eBay Integration: What to Start With?

Find out how to create eBay listings from product grid and manage them via eBay integration addon. Read More…

Card image
How to Connect PrestaShop to Amazon and Create Listings There

Use these guides to create and update product listings on Amazon. Manage orders using Amazon Integration Addon. Read More…

Card image
PrestaShop IceCat Integration: Detailed Step-by-Step Instructions

Get detailed instructions on how to synchronize your PrestaShop store with IceCat via IceCat Integration Addon. Read More…

Be the first to comment.