Can I do a bulk update / insert of all my products for an event / product group?

Modified on Tue, 19 Dec, 2023 at 12:48 PM

You can update all of your products in bulk and even insert new ones.

  1. Browse to "Admin" > "Product Groups" and then select "Products / Vouchers" to access all of your products.

  2. In your main "Manage" menu click "Bulk Product Update / Insert (Beta)".


  3. Follow the steps in the "Bulk Product Update" window to create your spreadsheet.


  4. We'll create a backup of your data so if anything goes wrong we can always recover it.

  5. We'll cycle through all the products in the spreadsheet and make any updates where possible. Add any new products you want to upload by entering your data in the same format but leave your PRODUCTID column empty. Note that if you don’t define a PRODUCTSKU for a new product or do define one that already exists, we’ll use the new ID of the product created as the SKU so it’s unique.

  6. Dates & Times cannot be updated. If you need to update sales dates and times for all of your products you can do this in your product group settings.

  7. To update stock qty, ensure you use the PRODUCTSTOCKQTY column. The PRODUCTAVAILABLEQTY column is calculated: PRODUCTSTOCKQTY - PRODUCTSOLDQTY = PRODUCTAVAILABLEQTY. On a more complex e-commerce system you would have inventory management where you add stock in and out. On the PTA Events platform you simply increase the PRODUCTSTOCKQTY.

* This functionality is in beta so please email support@pta-events.co.uk if you have any issues.

** If you change data types - for example you enter some text in a number field then the update / insert will fail.


For a list of all Product Type IDs, please see here.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article