Automate your replenishment with the BigQuery integration

Optiply reads products, stock, suppliers and orders from BigQuery with queries tailored to the data. Optiply's supply chain agent follows the guardrails set by BigQuery data and internal purchasing rules, so teams stay in control while orders run automatically. Every decision is explained on SKU level.

Integration type

Database

Turn BigQuery data into purchasing decisions, automatically

If your commercial data lives in BigQuery, Optiply can use it directly. Tailored queries shape your tables into the fields Optiply needs, so you work from current numbers.

  • The supply chain agent forecasts demand from the data in your warehouse
  • Tailored SQL queries arrange your own columns into Optiply's fields
  • Purchase orders and receipts can be exported back to BigQuery
Turn your system data into purchasing decisions, automatically

How it works

From BigQuery data to a purchasing decision in four steps

1

Connect BigQuery to Optiply

Connect BigQuery to Optiply
Prepare a Google Cloud service account with a JSON key for BigQuery. Queries are tailored to your tables. The supply chain agent checks and cleans that data before it advises.
Connect BigQuery to Optiply
2

Set your inventory targets and purchasing strategy

Set your inventory targets and purchasing strategy
Set the inventory targets and purchasing rules that fit your business, with products prioritised by margin, revenue and sales.
Set your inventory targets and purchasing strategy
3

Review your purchasing advice

Review your purchasing advice
Optiply's supply chain agent learns your buying process and turns it into daily purchasing advice, explained on SKU level. Over time it needs less oversight and only flags what falls outside the guardrails.
Review your purchasing advice
4

Automate your replenishment

Automate your replenishment
The supply chain agent can place orders and handle supplier communication and invoice discrepancies. The more it is used, the more it learns from the data and manual adjustments.
Automate your replenishment

Whatever system you use, we can connect to it

Optiply easily integrates with e-commerce software, warehouse software, ERPs and more. Any e-commerce store, warehouse or physical store can be linked.

CMS & e-commerce software

Automate your purchasing directly from your online store.

ERPs & CRMs

Easily synchronize purchasing, inventory and sales.

WMS & fulfillment software

Coordinate your purchasing with real-time inventory data.

FAQ

Frequently asked questions about the

BigQuery

integration

How does the BigQuery integration work?

Optiply runs tailored SQL queries on your BigQuery data to import products, stock, suppliers, supplier products, sales, purchases, receipts and compositions. The supply chain agent turns them into purchasing advice that you review or automate to your own rules.

Why connect BigQuery to Optiply?

If your commercial data already lives in BigQuery, Optiply can use it directly. The supply chain agent turns it into daily purchasing advice and explains every decision on SKU level, while the team keeps its own rules.

What do I need to connect BigQuery to Optiply?

A Google Cloud project with the BigQuery API enabled, and a service account with a JSON key. The service account needs the BigQuery Data Editor and BigQuery Job User roles. Keep the key file private and never paste it into a support message.

How long does it take to connect BigQuery to Optiply?

There's no fixed setup time for connecting BigQuery to Optiply, because it depends on the setup and data. Connecting the account and the first data import are separate steps, so confirm both with Optiply Support for a reliable timeline.

How can inventory automation help a business that keeps its data in BigQuery?

Having the data isn't the same as acting on it. Automating replenishment turns your products, stock and sales into daily advice, so the team reviews proposals instead of building reports and can help avoid stockouts and excess stock.

Do I stay in control of purchasing decisions?

Yes. The supply chain agent follows the rules set by the team, explains every recommendation on SKU level and only flags what falls outside them. How much to automate is a choice.

Always make the right purchasing decisions

Keep control of your supply chain. Know exactly what, when and where to buy and always place the right orders to maximize revenue.

Get a demo

“The fact that Optiply makes the calculations, analyses the sales of the past few years and can therefore make a prediction saves me a lot of work. That time saving is really the trigger.”

Martijn Janssen

Buyer & Sales Manager

,

Fitwinkel