Enter the password to open the stock planner.
| Veeqo SKULeyton SKU | Description | Demand2 months | Leytonin stock now | % of Leytonfor new qty | New qtyVeeqo total | Status | Review | Notesshared with every tab |
|---|
| Veeqo SKULeyton SKU | Description | Demand2 months | Leytonin stock now | % of Leytonfor new qty | New qtyVeeqo total | Status | Review | Notesshared with every tab |
|---|
| ProductVeeqo SKU, description | This period | Previous | Change | Shareof all sales | Veeqoavailable | Last 13 weeksoldest → latest | Avg priceper unit, ex VAT | Main channel |
|---|
Every product with a note, newest first. These are the same notes shown on the Stock import, Stock cover and Sales analysis tabs: change one anywhere and it changes everywhere. Clear a note's text to remove it. Discontinued lists every line marked as discontinued (with or without a note); press Not discontinued to bring one back on the Stock import and Stock cover tabs. Use Mark discontinued under a note's type, or Mark discontinued… for any SKU. Use the links under each SKU to jump to it on another tab. Import notes takes an Excel or CSV file with a "Veeqo SKU" column and a "Note" column; the Download file is in that format, so you can download, edit in Excel and import it back.
| Veeqo SKUdescription | Type | Note | Last changed | Demandper month | Veeqo stockavailable | Covermonths | Leyton stocklast import |
|---|
Upload the latest Leyton report (CSV, .xlsx or .xls). Veeqo orders since the report are taken off automatically.
Upload the Leyton stock export (.xls, .xlsx or .csv). The app reads the reference and In Stock columns for every Leyton SKU in your mapping, confirms which day the report is from (read from the file name where it can), finds the cut-off from when Veeqo orders stopped shipping that day, and takes off orders shipped after it plus orders not shipped yet (re-checked on every pull). Uploading replaces the previous stock figures and clears all reviews (ticks and entered quantities), so everything over the review % is checked again.
Which Veeqo SKU goes with which Leyton SKU, and any % rules. Upload the workbook or change single products.
One workbook with two sheets: Rules (Leyton SKU and the % of Leyton stock to send, which replaces the normal check), SKU to include (Veeqo SKU and its Leyton SKU). Uploading replaces both. Notes, ticks and entered quantities are kept, and new SKUs pick up their Leyton stock and Veeqo details automatically.
One button pulls new orders, stock levels, product details and kits from Veeqo.
Demand is the number of units on shipped orders across all channels, except orders fulfilled by Amazon (FBA), created in the last 3 months. Pull everything from Veeqo does it all in one go: new shipped orders, then one read of the whole Veeqo catalogue for stock levels (Stock cover tab), fresh product details for every mapped SKU (titles, IDs, price, tax rate) and kit links. Pull stock levels only skips the orders.
A morning summary of Steps 1, 2, 3 and 5 on the Stock cover tab for Leyton products and for other products: a snapshot of how many lines need action, with details of only the lines that are new since the last email. Sent from your own mailbox.
After the send time, the planner refreshes everything from Veeqo, builds the report and sends it. On weekday mornings a scheduled job opens the planner by itself to do this, so nobody needs to be logged in; otherwise the first time anyone has the planner open after the send time, it sends it. Only one copy is ever sent per day, even with several people logged in. If the refresh fails, the email still goes, marked NOT REFRESHED with the reason. If sending itself fails (mailbox problem), the next person to open the planner tries again, up to 3 times a day. Discontinued lines are always left out. Leyton stock isn't uploaded daily, so the email shows the last known Leyton figure with its date, and warns when that file is old.
The mailbox's outgoing (SMTP) details. On Krystal: cPanel → Email Accounts → your mailbox → Connect Devices. The password is kept on the server and never shown again.
Changes apply straight away and are saved for everyone.
Packs and kits sold, counted against the products they take stock from.
In Veeqo, packs and kits (for example FRCT5-10 or DL111573-RGB) are set up as kits that take stock from their components. An order only records the kit sold, so each kit sold is counted against its components using the quantities set in Veeqo: FRCT5-10 counts as 10 of FRCT5. Kit details are saved, so only new listings are checked on each pull.
| Kit sold | Component | Qty in kit | Kits shipped | Units counted |
|---|
Veeqo titles whose *CODE* doesn't match the mapped Leyton SKU.
Compares the code between the asterisks in each Veeqo title (e.g. *JET-WH-3K*- Fire Rated…) with the Leyton SKU in your mapping. A difference usually means the mapping points at the wrong Leyton product. Uses the Veeqo details already pulled; press Refresh product details if titles have changed.
| Veeqo SKU | Mapped Leyton SKU | Code in Veeqo title | Veeqo title | Result |
|---|
Mapped SKUs that need fixing before they can be exported.
| Veeqo SKU | Leyton SKU | Problem |
|---|
The login password is never stored as text, in the website’s files or in the browser: the server keeps only a one-way scrambled copy (a hash). After logging in, the browser holds a session key that ends after 12 hours without use, on Sign out, or when the password changes. Eight wrong passwords from one place lock logins from there for 15 minutes.
Everyone else is logged out and needs the new password. You stay logged in.