Bulk operations (prices, stock)

When you have hundreds or thousands of products, editing them one by one is not an option. VentasxMayor handles bulk changes in two ways: a percentage price increase or decrease, and a round trip that exports your catalog to a Google Sheets spreadsheet, lets you edit it there, and imports it back.

⚠️ Before importing a spreadsheet: missing products get deleted

Spreadsheet import deletes from your catalog every product whose code is not in the file. It does not hide them: it deletes them, and the deletion drags along the options, the price-list prices, the product photos and the cart lines the product was sitting in. It is the most expensive mistake you can make on this screen.

The rule is simple: the spreadsheet you import has to contain your complete catalog, not just the rows you want to change. If you are changing ten prices, export the whole catalog, change those ten rows and import the complete file back.

Two safeguards worth using every time:

• The preview. Importing applies nothing immediately: first the Import preview screen opens, showing how many products will be created, how many updated and how many deleted. If you see a number under Deleted Products you were not expecting, click Cancel. Nothing has happened yet at that point.
• A backup copy. Export the catalog and save that spreadsheet before any large import.

If you have already lost products to an import, write to support with the date and time just before the deletion. VentasxMayor keeps the full catalog history and the team can restore it to that moment, but the restore is run by the VentasxMayor team, it is not available in your panel. The sooner you ask, the less later work is lost.

Step by step

Raise or lower all prices by a percentage

1. In the side menu, go to Settings → Tools.
2. Find the Bulk Price Increase card.
3. Under Percentage type the number. Positive raises and negative discounts: 30 raises everything by 30%, -5 lowers everything by 5%.
4. Under Price List choose General to touch base prices, or one of your lists to touch only that one.
5. Turn on Round? if you want whole values. The on-screen help shows it: $123.45 → $123.00.
6. Click Increase prices and confirm in the Apply price increase? dialog.

The change is immediate and cannot be undone. The screen reloads with the new prices; there is no background task and no progress bar for this operation.

Change anything else in bulk (spreadsheet)

1. In the side menu, go to Settings → Tools.
2. On the Product Management in Google Drive card, under Export products, click Download spreadsheet. Despite what the name suggests, that button does not download a blank file: it exports your complete catalog into a new Google Sheets spreadsheet.
3. Open the Task Center with the icon in the top bar, wait for the task to finish and click the download icon: the spreadsheet opens.
4. Edit what you need, without deleting the rows of the products you want to keep.
5. Copy the spreadsheet URL, paste it into Import product spreadsheet and click Start import.
6. Check the Import preview and click Apply Changes, or Cancel if the numbers are not what you expected.

The exact spreadsheet format, the Google Sheets errors and the preview detail are in Importing products.

Upload many photos at once

1. Build a ZIP file where each photo is named after the product code: AB-100.jpg, AB-101.jpg.
2. If a product has several photos, put a folder named with the code and the photos inside: AB-100/1.jpg, AB-100/2.jpg.
3. To assign a photo to a specific option, name the file inside that folder with the option code: AB-100/AB-100-RED.jpg. Files whose name does not match any option code are loaded as product photos.
4. In Settings → Tools, find the Batch import images and videos card and pick the ZIP.
5. The screen builds a table with the recognised codes, the product name and how many photos each one brings. Codes that do not exist in your catalog are dropped automatically and do not appear in that table.
6. Click the Import button, which shows the photo and product count.

Despite the card's name, the importer processes images only. Videos cannot be uploaded this way.

What the bulk price increase does exactly

The scope changes with what you pick under Price List, and the difference matters:

• With General, it updates the base price of every product and also the price of every option (sizes, colours, formats).
• With a list selected, it updates only that list's price. It does not touch option prices.

Two more things worth knowing:

• Products with a price of 0 or no price are left out. The increase skips them. Besides, a percentage of zero is always zero. If your catalog is at $0 and you want to price it, the spreadsheet is the only route.
• There is no filter by category or by brand. The only available scope is the price list. To raise the price of a single category, export the spreadsheet, sort or filter by the CATEGORIA1 column inside Google Sheets, change the PRECIO on those rows and import the complete file back.

What you can change from the spreadsheet

The sheet is called Productos and starts with the columns CODIGO · NOMBRE · OPCION · BULTO · DESCRIPCION · DETALLE · VISIBLE · NUEVO · STOCK, followed by the categories, the PRECIO and one column per price list. One row per product plus one extra row per variant.

To add variants to a product that has none, add rows below its own and fill in the OPCION column with the size, colour or format. On those rows, the CODIGO is the variant's own code.

The CODIGO is the key the system uses to recognise each product. If you change it in the spreadsheet, the system does not read it as an edit: it creates a new product with the new code and deletes the old one, with everything that drags along. Product codes are not changed through the spreadsheet.

Careful with the STOCK column during a price change. The import overwrites stock with whatever the file says. If you exported on Monday, sold all week and import that same file on Friday to update prices, stock goes back to Monday's values. Export again right before importing.

What can and cannot be changed in bulk

With the spreadsheet you can bulk-change: name, options, units per pack, description, detail, visibility, the new-product flag, stock, categories, base price and the price of each list.

What has no bulk route today:

• There is no multi-select in the product list. There are no checkboxes for marking several products and applying an action in one go. Whatever is solved by spreadsheet is solved through the matching column: VISIBLE to show or hide, STOCK for stock, BULTO for units per pack.
• Featured does not travel in the spreadsheet. There is no bulk way to set or remove the featured flag on products.
• There is no per-item minimum purchase quantity. The minimum purchase is defined for the whole business and, if needed, per customer. What is configured per item is the pack, which travels in the BULTO column of each option row.
• There is no bulk delete button. The real route is the spreadsheet: export the catalog, leave only the products you want to keep in the file, import and confirm in the preview. Everything you removed from the file gets deleted. Use it with the warning at the top firmly in mind.

Where an export shows up

Exports and imports run in the background and are recorded in the Task Center, the icon in the top bar. Each task shows its status (pending, processing, completed, failed or cancelled), its progress in items and the error message if it failed. You can keep working while they run and clear the finished ones when you no longer need them.

The exported spreadsheet is not emailed to anyone. There is no destination address to configure: the file is created in Google Drive and the link is downloaded from that task's button in the Task Center.

Bear in mind that the spreadsheet is left with edit permission for anyone who has the link. If it contains prices you do not want circulating, do not share that URL; copy the spreadsheet to your own Drive and set the permissions there.

Google Sheets does not accept cells longer than 50,000 characters. If a product has a huge DETALLE, the export fails and the message names the product. Shorten it and export again.

If the import fails

The three usual errors are the Sheet's permissions, an incomplete link and a tab not named Productos. The on-screen message tells you which one it is and how to fix it. The complete list, along with the file formats Google does not accept, is in Importing products.

The preview has a five-minute timeout. If it runs out, launch the import again.

If you cannot find it

• You do not see the Tools screen in the menu. It requires the Tools permission. Ask the account owner for it in Settings → Manager.
• You do not see the Bulk Price Increase card. On top of the Tools permission, the increase requires full product permission. A user with products in read-only mode cannot apply it.
• You do not see the Export historic button. It appears next to Download spreadsheet only with the Tools or administrator permission. It exports the catalog as it stood at an earlier date and time; if you then import that file, your catalog goes back to that state. Save a copy of the current catalog before using it.
• You do not see the customer import card. It needs the customers permission.
• You cannot find "Bulk". It does not exist: Settings → Tools is a single screen made of cards, with no tabs or subsections.
• You uploaded a CSV or Excel product file and it did not work. The Import products from ERP card accepts bespoke files, configured one by one for each business; if yours is not configured, the import is rejected. The general route for everyone is Google Sheets. See Importing products.

Tips

• Before any increase, export the spreadsheet and save it. It is your only way back without asking for help.
• Try the spreadsheet on a small change first: export, change two prices, import and look at the preview. Once you understand what each counter shows, large changes stop being scary.
• If you are raising prices by list, remember options are not touched. Check a product with variants afterwards to confirm it came out the way you expected.
• To work comfortably in Google Sheets, freeze the first row and filter by CATEGORIA1. That is the practical way to solve "raise just one category".
• If you upload the same photo ZIP twice, the second run does nothing: the system skips files already imported, identifying them by name. To replace a photo, rename the file.