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.
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.
Step 2. Specify Product Export Configuration Settings
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:
- “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:
“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.
“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.
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.
After everything’s ready with the products, click on the ‘Process’ button for export. The export results will be shown in the progress bar.
Once the export is finished, click ‘Close’ to complete the process and exit the addon.
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…
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…
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…