If you need to edit several variables of multiple products at the same time, you can use 3dcart's Multiple Update feature. The Multiple Update feature allows you to filter your products by category. After you have chosen the category of products you wish to update, you can then choose the specific variables you would like to edit and make the change all at once.
- Go to Products ->Product list
- Look towards the top right of the page and click on the "More" button
- Select "Batch Update"
You will see a search bar at the top of the page where you can enter a keyword to search for products. Next to the search button, you will see a button labeled "Advanced" which will let you narrow the search for products from a specific category, distributor or manufacturer.
Then, along the bottom of the advancd search window, you will see a list of editable variables which can be selected for the Batch Update.
- Choose the category of products you would like to edit in the Category dropdown.
- Select the variables you would like to edit for each product. You can edit up to 5 different variables simultaneously.
To select multiple variables at the same time, click them while holding down your CTRL key
Below is a list and brief summary of the variables available in the Multiple Update section:
By default, the cart will display the five most common variables at the beginning - ID, name, price, stock and weight. However, you can choose any 5 at a time that you need.
The Product ID/Sku number of the product
The unique manufacturer ID of the product.
The name of the product.
The base cost of your product.
This variable is for internal use and not displayed to the customer.
The price of the product that you want to charge your customers.
The retail price of the product.
The sale price of the product.
Mark the product as On Sale.
This is a boolean parameter where 1 = on and 0 = off.
In this case, type 1 for "On Sale," and type a 0 for not on sale.
The quantity on hand of the product.
The weight of the product.
This is a markup, or handling fee to the product.
Mark the product as free shipping. Type a 1 to specify free shipping, type a 0 to disable free shipping.
Once you have edited all of your variables, click Save Changes to commit them on the cart.
If you have more than 5 variables to edit at one time, it would probably be be best to use the CSV export/import functionality instead.
Additionally, you can create custom export sets which will allow you to edit (via import) as many variables as you need.