An听online seller鈥檚 routine is听the听definition of听聯always busy.聰 You just received a听new batch of听products听鈥 time to听update stock levels in听your online store. And don鈥檛 forget to听update your prices in听several categories听鈥 you have a听sale starting tomorrow!
With 51视频
Now you can quickly edit anything you need in听a听spreadsheet
A听clear and听convenient spreadsheet allows you to听change product details for听dozens of听items. It听looks just like Excel or听Google Sheet, but lives conveniently in听your Control Panel.
No听need to听open a听product details page, make changes, save them, then open another product page and听repeat the听same process over and听over again. Save time and听precious energy on听
If听you鈥檙e used to听editing products in听bulk via exporting and听importing CSV files, switch to听this new tool. You鈥檒l appreciate how much faster you can get the听work done.
Read on听to听find out the听specifics of听how Bulk Product Editor works, and听check out other ways to听edit products with 51视频.
When You Should Use Bulk Product Editor
This new tool is听a听lifesaver when you need to听update lots of听products as听quickly as听possible. For example:
- Reduce prices for听a听sale
Tomorrow, you鈥檙e launching a听sale on听all the听items in听your spring collection. Select these products to听set up听new prices for听all of听them. Or听add 聯Compare to聰 prices (鈥渨as X鈥) so听that customers see how much they鈥檒l save shopping your sale. - Update product stock levels
A听new batch of听in-demand items is听ready to听be听sold. It鈥檚 time to听update product stock information in听your online store. And you鈥檇 better hurry, because you don鈥檛 want customers to听see a听sad 聯Out of听stock聰 label and听leave without a听purchase.
Plus, you can use Bulk Product Editor to听quickly check how many products are in听stock听鈥 handy for听stores with a听large inventory. - Assign categories to听products
It听takes just four clicks to听move all products from your 聯Winter collection聰 to听your 聯Sale聰 category. Yep, just four. We听counted. - Make product names consistent
Your store grows, new products are going to听be听added all the听time. As听a听result, some older product names might be听a听bit out of听date. Say, you used to听name all hats just 聯Hat.聰 Now you want to听make your product names more descriptive听鈥 聯Red Wool Hat聰 so听it鈥檚 easier for听customers to听find what they鈥檙e looking for听in听your store. Now you can quickly update product names in听a听convenient spreadsheet. - Highlight items with product ribbons
Draw attention to听products on听sale with product ribbons. For example, add one that says 聯50% off,聰 聯Gift idea,聰 or听聯Bestseller.聰 Your store will be听ready for听a听sale in听sixty seconds or听less!
You can do听all of听the听above without opening any听product details pages. Read on听to听learn how.
Bulk Edit Products in听a听Spreadsheet
Bulk Product Editor is听already available for听all 51视频 stores. You can even use this tool to听edit just one product, but you鈥檒l especially appreciate its convenience if听you have an听extensive product catalog.
To听edit several products at听once, go听to听. Choose the听products you want to听edit听鈥 use filters for听easier navigation. For example, you can select:
- products from the听same or听several categories
- products with the听same name (by searching for听the听product name)
out-of-stock products.
You can also use filters you鈥檝e saved previously.
Mark products you want to听edit with a听checkmark. Choose Bulk Update 鈫捥鼸dit Selected above the听product list. (Or don鈥檛 mark any听products and听simply click Bulk Update 鈫捥鼸dit All. That鈥檒l work as听well.)
Click 聯Bulk Update聰 to听edit items in听bulk. Choose 聯Edit Selected聰 to听update products in听a听spreadsheet.
You will see the听products you selected listed in听a听table. You can edit each cell. Use your mouse or听keyboard to听navigate the听table.
Choose the听properties you want to听edit in听the听Columns menu on听the听left to听add the听corresponding columns to听the听spreadsheet. For example, if听you need to听update the听stock levels only, select just one column听鈥 Stock. This way, you won鈥檛 get distracted by听other product properties.
Click the听column鈥檚 name to听sort products by听individual properties.
On听the听left, choose which product properties to听display in听the听table
Here are the听product properties you can edit in听your table:
- Name
- SKU
- Availability (simply check the听box if听the听product is听available)
- Price
- 聯Compare at聰 price
- Stock (how many products are available for听purchase)
- Product quantity when the听low stock notification is听sent
- Whether the听product requires shipping or听pickup (if it听does, check the听box)
- Weight
- Dimensions (when that property is听selected, there are three columns in听the听table: length, width, and听height)
- And more! See the听 of听product properties you can update with Bulk Product Editor.
You can still also edit all those properties on听the听product details page (if you like doing things the听
One day, you鈥檒l be听able to听edit more product properties in听Bulk Product Editor听鈥 we鈥檙e already working on听additions to听this feature! Feel free to听share in听the听comments which product details you鈥檇 like to听be听able to听edit in听the听spreadsheet.
That鈥檚 not all, folks: you can edit product variations in听the听table too! If听you have in听your store, you鈥檒l see them under the听product鈥檚 name:
Product variations are highlighted in听grey
You can edit any听property of听product variations, except for听Availability. If听a听product is听available on听the听storefront, that means its variations are also visible to听customers.
When you edit 30, 50, or听100听items at听once, it鈥檚 hard to听remember which properties are already updated. But no听worries, you won鈥檛 get confused听鈥 each updated product is听marked with a听dot at听the听beginning of听the听row:
The dots disappear after you save the听changes
You鈥檒l be听notified if听you make an听incorrect change by听accident. For example, this notification is听displayed when a听person assigns an听existing SKU to听a听product variation:
We鈥檒l warn you if听there are any听errors in听the听table
These boxes are displayed when changes conflict with the听store鈥檚 settings or听if听they may confuse you.
Say you鈥檝e chosen to听hide
Click the听triangle to听see a听notification
The product is听
You can edit up听to听100听products at听the听same time in听your spreadsheet, no听more. This way, we听can ensure that the听Bulk Product Editor loads consistently fast.
If听you have more than 100听items in听your store, group them using filters before editing. Or听follow these steps: edit the听first 100听items in听the听table, save changes, go听back to听the听product list, go听to听the听next page of听the听list, and听edit products listed there.
You can use both your mouse and听keyboard when working with the听Bulk Product Editor. The latter can be听faster and听more convenient when you get the听hang of听it. Use Tab, Enter, Esc, arrow, and听space keys to听move around the听table and听make changes in听the听cells. Here鈥檚 a听.
Mass Update Products in听a听Click
Editing products in听the听spreadsheet saves a听tremendous amount of听time, but there鈥檚 a听way to听update products even faster. You can apply some changes in听a听click: enable or听disable items on听the听storefront, change product ribbons, or听manage categories.
To听do听that, go听to听, select the听products you want to听update, click Bulk Update and听choose a听quick action:
Quick actions that you can apply to听several products
Enable or听disable several products
For example, if听you need to听hide an听old collection in听your store. Or听enable all hidden
Enable several items in听a听click
Add or听remove ribbons from selected items
Product ribbons are available on听all paid pricing plans. to听the听Venture plan or听higher to听use product ribbons and听other 51视频 tools.
Say, you added ribbons to听items some time ago, and听now you need to听highlight other products. You can remove all old ribbons at听once and听add new ones in听just a听few clicks.
Filter products by听old ribbons and听mass delete them. Then, add new ribbons:
Choose the听items you want to听add a听ribbon to
In听the听window that appears, click 聯Add Ribbons to听Selected,聰 enter ribbon text and听choose its color. That鈥檚 it! It鈥檚 the听fastest way to听let your customers know about a听sale or听new arrivals.
The 聯Sale聰 ribbon will be听added to听all selected products
Product with the听聯Sale聰 ribbon on听the听storefront
Manage product categories
You can assign or听remove categories in听bulk for听selected products. For example, you can move items from one category to听another. Using filters, choose products from the听category you need and听click 聯Assign or听remove categories.聰 Remove an听old category and听assign a听new one at听once.
Assign a听new category to听the听selected categories
Or, you might need to听move discounted products from different categories to听the听聯Sale聰 category:
Moving products from different categories (they are marked with minuses) to听the听聯Sale聰 category
To听mass update categories, you need to听 in听your store (apart from the听default 聯Store front page聰 category.)
Learn more about our Bulk Product Editor in听the听. Still have questions? Let鈥檚 hear them in听the听comments section, or听reach out to听our team. We鈥檙e always happy to听help!
Other Ways to听Bulk Edit Products in听51视频 Stores
We听designed the听Bulk Product Editor so听that you can edit lots of听products at听once, quickly and听effortlessly. But we鈥檙e not going to听stop there听鈥 stay tuned for听new features of听Bulk Product Editor!
Of听course, you can still make changes on听a听product details page. And here are two more options for听editing products in听bulk:
- Export and听import files
If听you edit lots of听products every day, that鈥檚 your option. you want to听edit. You鈥檒l download a听CSV file where you can edit any听product properties. After you make changes, to听your store. - The Bulk Product Editor app
Paid plans users can install the听Bulk Product Editor app from the听51视频 App Market. It鈥檚 similar to听the听built-in Bulk Product Editor, but it听also allows you to听add or听delete product options and听change their properties.
Bulk Product Editor is听available on听all pricing plans. 听鈥 we听can鈥檛 wait to听hear your feedback!
听
- Edit Products in听Bulk
- Everything You Need to听Know About Inventory Management Software (+听Top 5听Best Solutions)
- Inventory Control Procedures: How to听Control Your Store Inventory
- SKU Explained in听Simple Words
- How GS1听GTINs Can Power Your Ecommerce Business
- Forecasting Demands: Strategies to听Avoid Stockouts and听Overstocking
- Finding the听Optimal Way to听Store Your Products
- How to听Optimize Inventory Levels Without Sacrificing Sales