Upload your stock from a spreadsheet
Upload a spreadsheet of your cars and we put them on your website. You check the match and a preview of your cars before anything goes live. Only an owner or a manager of your website can upload. Everyone else can look but not change.
What file to use
- A .csv or Excel .xlsx file, up to 10 MB and 5,000 cars. One car per row. Excel's Unicode Text (.txt) export works too.
- Any layout works. We match your columns for you.
- If your file is .xls, .xlsm, .numbers or another type, open it and save it as .xlsx or .csv first.
- Starting from scratch? Use Download our template on the upload page.
What every car needs
- A stock number or a VIN (one is enough).
- Make, model and year.
- Price.
- New, demo or used, or the kilometres. If your file has kilometres, we work out the rest.
A car also needs at least one photo to show on your site. Cars without one are saved but kept off your site.
Steps
- Sign in at https://vyro.co/access.
- Open your showroom and go to Stock. You can also go to Inventory, choose New Vehicle, then Upload a spreadsheet.
- Choose Upload a spreadsheet.
- Drop your file on the page, or choose Choose a spreadsheet.
- On the Check your cars page, look at how your columns were matched. Change any that are wrong. If a detail is marked Needed and has no column, choose one.
- If a highlighted word needs an answer (for example what "SOLD" means), say what it means. Import stays off until every word has an answer.
- Look at the preview of your cars. The line above the button says how many are ready and how many are kept off, and why.
- Choose Import. The button shows the number of cars, for example Import 142 cars. Nothing is added until you do this.
Photos
- Put links to your photos in the file. Put several links in one cell (for example with a | between them), or use one column per photo.
- We copy your photos onto your own site so they keep showing.
- If a photo link can't be reached, that photo is left out. A car with no usable photo is saved but kept off your site.
Prices
- Use the price you want shown, as a number.
- If the price is a word such as POA or Enquire, with no number, the car goes on your site with those words shown instead of a price.
- A price in another currency keeps the car off your site until you say what to do with it.
Cars that are sold or missing
- Rows marked sold, or not for sale, are skipped.
- Each upload replaces the cars from your last file. A car that is in your last file but not in the new one comes off your site. Nothing is deleted, and the car comes back if it is in a file again.
- If a file would take more than half of your cars off your site, we ask first: This would hide a lot of your cars. Is that right? Choose Yes, hide them only if the file is right. Choose No, go back if you picked the wrong one.
- If your site was built from your old website, the cars copied from it stay until you stop the old website import. Importing never removes them.
Keep your stock up to date
A spreadsheet doesn't update by itself. When your stock changes, upload a new file. Go to Stock and choose Upload a new file. We remember your columns, so next time it's one step.
Contact details
Phone numbers and email addresses typed into a car's description are removed. You'll see a note about it in the preview.
If something goes wrong
| What you see | What to do |
|---|---|
| That isn't a spreadsheet we can read | Choose a .csv or Excel (.xlsx) file. Save other types as one of those first. |
| Save it as .xlsx or .csv first | Your file is an older or different spreadsheet type (.xls, .numbers). Open it, choose Save As or Export, pick Excel Workbook (.xlsx) or CSV, and upload that. |
| The file did not upload | Your connection dropped while sending. Check you're online and choose the file again. |
| We couldn't read that file | Check it opens in Excel or Numbers, then save it as .xlsx or .csv and try again. |
| That file is empty | Choose a spreadsheet with your cars in it, one per row. |
| That file has no cars in it | We found headings but no rows. Check you exported the full stock list. |
| That file is too big | Take out columns you don't need, like long descriptions, and upload again. Keep it under 10 MB and 5,000 cars. |
| A few details still need a column | Choose a column for each detail listed. |
| That upload has expired | We keep a file for 24 hours while you check it. Choose it again. |
| An update is already running | Wait a minute, then try again. |
| Only an owner or manager can do that | Ask an owner or a manager of your website to upload. |
Result
The result page says how many cars are on your site and what changed, for example how many were added, updated or kept off. Choose See the cars left off your site, and why to see each one.
