Prestashop
Pre-built tables and definition
Prerequisites
Before connecting PrestaShop to QUANTI, ensure you have:
PrestaShop Webservice Access: The Webservice API must be enabled in your PrestaShop back-office (Advanced Parameters > Webservice)
API Key: A Webservice API key with read permissions on the required resources
PrestaShop Version: PrestaShop 1.7+ recommended for full compatibility
Store URL: The base URL of your PrestaShop store (e.g.
https://yourstore.com)
Setup Instructions
Finish setup
Define a sync period and a lookback window — Click save
For the first sync, you have the following options:
Activate auto-sync for recurring syncs based on your sync settings by clicking the switch button
Launch a historical data recovery by choosing your desired dates in the historical data tab
Launch a manual sync immediately by clicking the Sync now button
Wait for the sync to complete. Then navigate to your data warehouse to verify that tables are populated
Check the connector dashboard for sync status and any potential errors
Pre-built Tables
Dimensions
Carrier : Shipping providers with delivery methods, rate calculation mode, weight limits, and active/deleted status.
Cart_rule : Discount rules and coupon codes with percentage/fixed reductions, free shipping flags, validity dates, and usage limits.
Category : Hierarchical product classification tree with parent-child relationships, names, and activity status.
Customer : Customer profiles including demographics, registration date, newsletter subscription, and guest vs. registered account status.
Product : Product catalog with names, references, barcodes (EAN13/UPC), base prices, wholesale prices, weight, category and manufacturer associations.
Product_variant : Product variant/combination level detail with SKU, barcodes, price and weight impact relative to the parent product.
Facts
Order : Orders with full financial breakdown: products total, shipping, discounts, and amount actually paid. Linked to customer and carrier.
Order_line : Individual line items per order with product references, quantities ordered/refunded/returned, and unit/total prices (tax included and excluded).
Order_cart_rule : Junction table tracking which discount rules were applied to each order, with the actual discount values.
Transaction : Payment transactions with amounts, payment method, external gateway transaction ID, and currency conversion rate.
Last updated