Export PrestaShop Orders to QuickBooks Online - Store Manager for PrestaShop
Rating 0.00 stars - 0 votes

Export PrestaShop Orders to QuickBooks Online

Nowadays, efficient management of orders and accounting processes is paramount for business success. For PrestaShop users seeking simple and accurate integration with accounting software, exporting orders directly from their PrestaShop store can significantly streamline their accounting workflow. This article will guide users how to export PrestaShop sales with ease in a few steps specifically to QuickBooks Online.

1.Create Configuration Window

Launch the QuickBooks Online addon, authorize and select ‘Export Orders’ option.

Export Orders Option in QuickBooks Online Addon for PrestaShop

Before diving into the specifics of order export settings, you must create a configuration in the addon. After that you’ll be forwarded to the next window with the detailed settings.

New Export Orders Configuration in QuickBooks Online Addon for PrestaShop

2. Orders Export Settings

This step encompasses various data points and options to ensure comprehensive synchronization of order information.

Order Export Configuration Settings in PrestaShop QuickBooks Online

These settings include:

Orders Filter. Selecting specific criteria for order selection, such as date range and order status allows users to filter out relevant orders for export.

Order status includes the possibility to choose: Canceled, Closed, Complete, Suspected Fraud, On Hold, Payment Review, PayPal Canceled Reversal.

Time period: Last 7 days, Last 30 days, Today, Yesterday, This Week, Last Week, This Month, Last Month, This Year, Last Year, Custom.

Tax Options. Configuring tax settings ensures accurate calculation and recording of taxes applied to each order in QuickBooks Online.

Embedded List of Tax Options for PrestaShop Order Export to QuickBooks Online Addon

Enabling ‘Apply taxes’ option allows configuring the fields Order tax, Taxable and Non Taxable. In case they are empty, use the buttons on the right to refresh them and get the embedded options.

Customer Options determine how customer information is handled, including whether new customers are created in QuickBooks or matched with existing records.

Use the macros from a list for a template in the Display name dropdown.

Customer Display Name Macros in QuickBooks Online Addon During PrestaShop Order Export

“Create customer if doesn’t exist” option should be enabled in case the customer doesn’t exist in QuickBooks Online, but available in the order details that are being exported. This way, a new customer in the QuickBooks customers list will be created.

Product Options define how products are mapped and categorized within QuickBooks, ensuring consistency between PrestaShop listings and QuickBooks Online inventory.

Product Options Settings During PrestaShop Order Export to QuickBooks Online

Specify Item nameProduct Name or SKU for items identification.

Enable the “Create product item if doesn’t exist” option if needed.

Item type: Inventory, Non-inventory and Service.

Inventory asset account: Inventory Asset, Inventory Shrinkage, Land, Legal & accounting services, Accounting fees, Legal fees, Lines of credit, Loans to others.

Income account: Sales of Product Income, Sales tax to pay, Shipping, Short-term business loans, State estimated taxes, Supplies, Supplies & materials, Taxes paid.

Expense account: Cost of goods sold, Equipment rental, Subcontractor expenses, Supplies & materials, Cost of Goods Sold-1, Customer prepayments, Depreciation, Employee benefits.

Discount area allows handling discounts applied to orders and reflecting them accurately in QuickBooks.

Select whether you want to export discount as value, as item and if you want to apply tax after discount.

Discount item – in this case you need to select an item from a list.

Discount and Shipping Settings in QuickBooks Online During PrestaShop Order Export

Configuring Shipping settings allows capturing shipping costs and methods for each PrestaShop order, facilitating accurate financial reporting in QuickBooks Online. Enable the corresponding option whether you want to export shipping as value or as an item.

Export shipping as an item allows selecting an item from a list which will be reflected as a shipping after order export.

After all is set up, hit “Verify&Save” button to proceed.

3. Export Process

After all is set up and you can see your active export configuration with the list of orders, press the “Process” button to launch the export itself. The process can be checked in the progress bar.

Export Process of PrestaShop Orders to QuickBooks Online

After PrestShop order export is finished, you can check the result in QuickBooks Online accounting.

Benefit from Store Manager convenient opportunity to export PrestaShop orders 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.