Get Anything to Database Shopify Sync
Download the version that matches your Odoo from the Odoo Apps store. Products that start as supplier price lists (PDF, spreadsheet or scan) can be loaded into Odoo first with the supplier catalog importer.
Send your Odoo products and stock to Shopify
Anything to Database Shopify Sync is an Odoo module that keeps one Shopify store in line with Odoo. You work in Odoo; the store follows. One way: Odoo sends products, variants, prices, pictures and stock, on a schedule, with a log and no duplicates. This page is the full setup guide.
$149 one-time on the Odoo Apps store.
What it does
- Products: tick "Publish to Shopify" on a product and it is created in the store with its variants, SKU, barcode, price, vendor, product type, tags and pictures. The title is the first line of the product name.
- Variants stay together: the attributes that make variants (length, colour, size) become Shopify options. One Odoo product is one Shopify product, each variant with its own SKU and price.
- No duplicates: every Shopify id is remembered, so the next send updates the same product. An unchanged product is not sent again.
- Stock: each Shopify location is mapped to an Odoo warehouse or stock location; the free, on-hand or forecasted quantity is sent. Only changed quantities are sent.
- On a schedule: every 15 minutes by default (5 minutes to once a day, or off), Odoo sends the products edited since their last sync and the stock that moved, within Shopify's rate limits.
- A clear log: one line per product and per stock send, with Shopify's own error text. Failed sends are tried again with a growing delay, and a Retry button puts one back in the queue.
Not included: orders, customers, refunds, payouts, two-way stock, multi-store, Shopify Markets and metafields. The Shopify app it uses needs product, inventory and location access only; it reads no customer data and no order data.
Before you start
- Odoo 18 or 17 on your own server or on Odoo.sh. Odoo Online cannot install modules that carry Python code.
- An Odoo user with the Settings (Administration) rights. The module needs the Sales and Inventory apps.
- A Shopify account that can open the Shopify Dev Dashboard for the organization that owns the store.
1. Install the module
Put the module folder in your Odoo addons path, restart Odoo, then open Apps > Update Apps Listand install "Anything to Database Shopify Sync". Odoo reads new module folders, and their icons, when it starts: without the restart the icon does not show in Apps. The module adds a Shopify Sync app with the menus Sync now, Products, Log, Queue and Configuration.
2. Create the app in the Shopify Dev Dashboard
Since 1 January 2026, new apps that work on a store you own are made in the Shopify Dev Dashboard. An app made in the Shopify admin before 2026 keeps working with its Admin API access token (see step 3).
- Open dev.shopify.com/dashboard and sign in with the account that owns the store.
- With Apps selected on the left, click Create app (top right), choose Start from Dev Dashboard, give the app a name and click Create. The name cannot contain the word "Shopify": use, for example, "Odoo Sync".
- On the app's Versions page: leave App URL as it is, leave Allowed redirection URL(s) empty, switch the embedded-app option off, and in Scopes enter these five and only these:
read_products,write_products,read_inventory,write_inventory,read_locations. Then click Release. - Open the app and click Install app at the top of the Installs box. Pick your store in the page that opens and click Install. Shopify then opens the App URL; a placeholder page such as "Example Domain" is normal.
- In App settings, copy the Client ID and the Client secret.
The store and the app must be in the same organization. The install page lists only the stores of the app's organization: if your store is not in the list, the app was made in another organization, so create it again in the one that owns the store.
3. Connect Odoo to the store
Open Shopify Sync > Configuration > Settings and fill in the store address (your my-store.myshopify.comaddress, not a custom domain), the app type "Dev Dashboard app (Client ID and Client secret)", the Client ID and the Client secret. Leave the API version at its default (2026-07). Click Save first, then Test connection: a click on Test connection while the settings still have unsaved changes only saves them.
Odoo reads the store's name and currency, the app's access scopes and the store's locations, then shows a message such as "Connected to My Store (https://my-store.myshopify.com). Currency: USD. 1 location found." With a Dev Dashboard app, Odoo asks Shopify for an access token when it needs one; the token lasts 24 hours and the module asks for a new one before it ends. There is nothing to renew.
What the messages mean
| The message says | What to do |
|---|---|
| "refused the Client ID / Client secret (HTTP 400)" | One of the two values is wrong, or the app is not installed on this store, or the app and the store are in different organizations. Shopify's own words follow: "invalid_request Missing or invalid client secret". |
| "answered 'not found' (HTTP 404)" | The store address or the API version is wrong. Use the myshopify.com address. |
| "refused the access (HTTP 401)" | The token or the credentials are wrong or were revoked. |
| "refused the request (HTTP 403)" | A scope is missing, or the app is not installed on this store. |
| "is missing these access scopes" | Add the scopes to the app, release a new version and approve it on the store. |
| "The store's currency is ... and the Odoo company's currency is ..." | A warning only: prices are sent as numbers, without conversion. |
Shopify's own words are shown after "Shopify said:" in each message.
4. Map the locations
In Shopify Sync > Configuration > Locations each Shopify location has one row. Pick an Odoo warehouse (its main stock location is filled in) or an Odoo stock location directly. A Shopify location that is not mapped gets no stock from Odoo. Refresh from Shopify reads the list again; a location Shopify no longer lists is archived in Odoo, not deleted.
5. Send the products
- Tick Publish to Shopifyunder the product's name. Then click Send to Shopify on the product to send it now, or select several products in a list and use Actions > Send to Shopify to queue them.
- New products arrive in Shopify as drafts (or active, a setting): a draft is under Products with the status Draft and is not on your Online Store. When it is ready, set it to Active and choose its sales channels in Shopify.
- A second send updates the same product and keeps its variants: never a duplicate.
- Pictures are uploaded again only when they changed in Odoo, and a changed picture replaces the old one in Shopify (one set of pictures, not two). Send again keeps the pictures that did not change; to send a picture again, remove it and add it back in Odoo.
- Shopify's vendor is the product's first vendor. With no vendor on the product and no Default vendor in the settings, Shopify shows your store's name as the vendor.
- The Shopifybutton on a product shows whether it was sent and opens its Shopify ids (on a narrow screen it sits under the product's More menu).
6. Send the stock
Choose what is sent in the settings: Free quantity (on hand minus reserved, the default), On hand quantity or Forecasted quantity. Only products Odoo keeps stock for are sent ("Track Inventory" in Odoo 18, the product type "Storable Product" in Odoo 17). Fractions are rounded down (3.6 becomes 3) and a negative quantity is sent as 0. Only changed quantities are sent, in batches. Before the first send of a variant to a location, the module switches on Shopify's inventory tracking for it. Click Send stock now to send at once; otherwise the scheduled sync sends the stock that moved.
7. Scheduled sync, queue and log
Scheduled sync runs every 5, 15 (default) or 30 minutes, every hour, every 4 hours, once a day, or Off. Shopify Sync > Sync now queues every ticked product and all the stock; unchanged products are checked and not sent again. A failed send is tried again after 5, 10, 20 and 40 minutes (5 tries in all) when the cause can pass. When Shopify refuses the store as a whole (a wrong secret, an unknown store), the run stops at once and the log says why in plain words, for example "The sync stopped: Shopify refused the access token or the app's Client ID / Client secret. 7 job(s) wait for the next try." Fix the settings, click Test connection, then Retry on the failed line or Sync now.
Odoo 17 and Odoo 18
The two versions do the same things; each has its own download on the Odoo Apps store. On Odoo 18 the stock setting on a product is "Track Inventory"; on Odoo 17 it is the product type "Storable Product".
Limits
- One Shopify store per Odoo database.
- Up to 100 variants and 3 options per product; a product above that is named in the log and not sent.
- Pictures: PNG, JPEG, GIF and WEBP; extra pictures need the eCommerce app; variant pictures are not included.
- Large catalogs sync in batches over several minutes, because of Shopify's rate limits.
- Sales channels are set in Shopify. The module never deletes a product in Shopify.
- Stock goes one way, from Odoo to Shopify.
Questions
- Does the Shopify Odoo connector import Shopify orders into Odoo?
- No. It works one way, from Odoo to Shopify: products, variants, prices, pictures and stock. Orders, customers, refunds and payouts stay in Shopify.
- Which Odoo versions does it work with?
- Odoo 18 and Odoo 17, on your own server or on Odoo.sh. Odoo Online cannot install modules that carry Python code, so it does not run there.
- What do I need on the Shopify side?
- An app created in the Shopify Dev Dashboard of the organization that owns your store, with five access scopes (read and write products, read and write inventory, read locations), released and installed on the store. Its Client ID and Client secret go into the Odoo settings.
- Does sending a product again create a duplicate in Shopify?
- No. Every Shopify id is remembered, so the next send updates the same product and keeps its variants. An unchanged product is not sent again.
- Are the products published on my Online Store?
- New products arrive in Shopify as drafts (or active, if you choose that setting). You set them to Active and choose their sales channels in Shopify.
- How is the stock sent?
- For each Shopify location mapped to an Odoo warehouse or stock location, the free, on-hand or forecasted quantity becomes Shopify's available quantity. Fractions are rounded down, a negative quantity is sent as 0, and only changed quantities are sent.