Help Center · Open to buy

Plan your buying with open to buy

Read the open-to-buy page: what each column means, how goals come from your own sales, and how to set growth, turn and budgets.

What it shows

Open to Buy shows, for each category and month, how much you can still spend on new stock and stay on plan. It is built from your own Lightspeed sales, stock on hand and open purchase orders.

It comes with every plan, on R-Series and X-Series. Show Me How, next to the page title, walks through it step by step with pictures.

The columns

  • LY sales: what the category sold in the same month last year.
  • Goal: last year's sales, grown by your Growth %.
  • Sales: what it has sold so far this month.
  • On hand: the stock you hold.
  • Plan: the stock the category should carry to support its goal at your Turn.
  • On order: open purchase orders due that month. An order with no date counts in the current month.
  • Open to buy: what is left to spend. A negative number means the category is already bought past its plan.
  • Budget: a spending limit you set. It turns red when what is on order goes past it.
  • M%: margin.
  • GMROI: gross margin return on the stock you hold. It needs 13 months of history.

Open to buy averages two readings of your plan: one against next month's stock plan, one against three months of forward cover. Tap a column heading in the app for its definition, or read open to buy and GMROI in the glossary.

The buying grid with one row per category and its money columns.
Four categories for one month. Home is already bought past its plan, so its open to buy is negative and its budget is red.

Set your plan

  • Growth % and Turn apply to the whole store. Not sure what turn to use? See how to set an inventory turn rate.
  • Move between months with the arrows, up to eighteen months ahead.
  • Choose one location, or All locations.
  • Value at switches every figure between Cost and Retail.

You can type over LY sales, On hand, On order and Budget in any row. A dot marks a number you set by hand, and its tooltip keeps the measured number. Type auto to return the cell to live data.

A pinned cell in the grid, with the note about pinned cells beneath.
Numbers set by hand carry a small dot, and the note under the grid explains it.

Import a plan from a spreadsheet

If you already plan in a spreadsheet, click Import plan, then Download template. Fill in one row per value: category, month, metric and value, with a location if you plan by location. The metrics are Budget, Last year sales, On hand, On order, Growth and Turn.

Preview shows every change before you click Apply import, and numbers you set by hand are never overwritten. More on this: open to buy from your spreadsheet.

Over-budget warnings

When you approve a line that takes a category past its budget for the month, Rebridge warns you with Budget exceeded for that category, so you can decide before the order is sent.

While your history loads

Until your history has loaded, the page shows what has arrived from Lightspeed: Sales history, Stock history and Purchase orders. Each one says Waiting for the first sync until Rebridge starts reading it, then Collecting now or Loading from Lightspeed while it arrives, and Loaded once it is in. Figures that depend on something still loading are marked incomplete until it finishes. After that, Rebridge refreshes them about every six hours.

Questions

Where do the goals come from?

From your own sales in the same month last year, grown by your Growth %. If a category has no sales last year, Rebridge uses two years back, grown twice. With no history at all, the goal is zero until you type one.

Does open to buy cost extra?

No. It is included in every plan.

Can I plan each location separately?

Yes. Choose a location at the top of the page, or All locations for the whole store. Spreadsheet imports can carry a location too.

Does open to buy work with X-Series?

Yes. It uses the same sales, stock and purchase orders on R-Series and X-Series.

Still need help?

Email support@rebridge.ai with the document name or purchase order number and what you see on screen. We reply within 24 hours. Or go back to the Help Center.