Google Sheets sync
DZBuild's Google Sheets integration keeps a live spreadsheet of your store data — orders, products, customers, stock changes, and abandoned carts — updated automatically as activity happens in your store.
Setup
- Go to
/dashboard/addons/google-sheets. - Click Connect Google and authorize via Google OAuth.
- Click Create new sheet (or link an existing sheet the app created). The background sync starts immediately.
If the token expires later, the page will prompt you to reconnect.
What syncs
| Data type | Columns written |
|---|---|
| Orders | order number, date, customer name, phone, wilaya, commune, address, products, variants, quantity, unit price, subtotal, shipping cost, discount, total, status, offer name — plus optional columns you can switch on: notes, promo code, delivery type, SKU, wilaya number. Courier and tracking number are not exported to Sheets. |
| Products | product id, name, price, old price, stock, category, has-variants flag, variants, status — plus one optional column you can switch on: SKU. |
| Customers | customer id, name, phone, email, wilaya, commune, number of orders, total spent, registration date |
| Stock updates | when a product's stock changes, the quantity cell of that product's row in the Products tab is updated in place. There is no separate Inventory tab, and variant-level stock is not written to the sheet (the Products tab's variants column is a text summary refreshed only on a full export). |
| Abandoned carts | cart id, phone, name, wilaya, commune, products, item count, cart total, status, created date, last activity — plus optional columns you can switch on: source page, email, wilaya number, variants, SKU. |
The first sheet you connect syncs all of the above. Additional sheets default to orders-only.
Per-sheet settings and columns
Every connected sheet has its own settings, so one sheet can be an orders log for your call-confirm team while another is a full catalogue export:
- Which data types it receives — orders, products, customers, stock updates, abandoned carts, or orders-only.
- Auto-sync on or off for that sheet.
- Which columns appear, and in what order — 22 order columns, 10 product columns, 9 customer columns and 16 abandoned-cart columns, each individually toggleable.
When you create a sheet you can also scope it to a specific list of products instead of the whole catalogue.
Exporting everything at once
Besides the live sync, there is a manual export now action that pushes existing data into the sheet in one pass — orders, products, customers, abandoned carts, orders + carts, or all of it. It runs in the background with a progress bar and is limited to 10 runs per minute.
Status changes are written back
When you change an order's status in the dashboard, DZBuild updates that order's existing row in the sheet rather than appending a duplicate. The same applies to abandoned carts (abandoned, contacted, recovered, expired), and abandoned-cart rows are colour-coded by status.
Active-sheet limits by plan
| Plan | Max active sheets |
|---|---|
| Free | 1 |
| Pro | 6 |
| Unlimited | 10 |
| Enterprise | 30 |
If you hit the limit you'll see: "لقد وصلت إلى الحد الأقصى للأوراق المفعلة". Disconnect an unused sheet or upgrade your plan.
Troubleshooting
| Issue | Fix |
|---|---|
| "Token expired" / reconnect prompt | Click Reconnect and re-authorize Google |
| Sheet stops updating | Check connection status; Google revokes tokens after prolonged inactivity |
| Can't create more sheets | Plan limit reached — see table above |
| Page says "not connected" although you connected it | The stored token could not be read; just re-link via Connect Google |
Disconnect does more than clear the link: it also revokes DZBuild's access on Google's side and wipes the stored tokens, so reconnecting means authorizing from scratch.
Octomatic
Octomatic is a third-party fulfillment tool that connects to DZBuild via Google Sheets. Set up Google Sheets first, then follow the guide at /dashboard/addons/octomatic.