Woocommerce is the best e-commerce platform in the world. Subject to September 2021, 93% of global WordPress e-commerce websites and 28% of e-commerce websites will be supported. Woocommerce built by Woo is a core product that can meet many, but not all, business needs. This is why word press themes such as Astra and Astra Pro are popular with millions of customers. This topic improves woocommerce in terms of speed and functionality. The ability to batch edit product information is another area where woocomerce needs some help. The
Enter the two plug-ins WP all export and WP all import of softy, a veteran WordPress software company. ‹ WP all export allows you to export data from word press or woocommerce database tables. The sister product all WP import can be used to import data and support batch update by itself. Combining these two functions, you can batch edit all the data in the woocommerce\/wordpress system. This includes data stored by third-party plug-ins and topics, such as Astra. The
What is catalog batch editing and why does woocommerce product need it? Batch edit woocommerce products using the spreadsheet step 1 – select the data type to export: Step 2 – apply the filter step 3 – select the export column step 4 – export complete step 5 – modify the title column step 6 – modify the selling price column step 6 – update the batch woocommerce products using the modified spreadsheet import vendor Edit stage 1 – select supplier update file upload and update object stage 2 – review import file stage 3 – main field mapping stage 4 – set matching field stage 5 – import completion stage 6 – confirm the real value of the updated product list batch editing function understand what batch editing is? Why batch editing wocommerce products? Need it? Imagine a reseller scenario where an online store sells products from hundreds of suppliers. Of course, the data of the product, especially the price and inventory level, will continue to change. Existing products can be deleted, but new products can be added. The
Manually updating the store with all these changes is not only error prone, but also a nightmare. WP all import automates the entire process, including the automatic search and processing of supplier files according to a predefined schedule. You only need to set it up for a supplier once and it will be completely free. From then on, the store will keep pace with the supplier! Now imagine deciding to change hundreds or thousands of existing products. Woocommerce needs to manually implement these changes one by one through the interface, which may take hours or days. The
To greatly shorten this process: Use WP all export to export relevant data to a spreadsheet. Modify data in spreadsheets that you can apply formulas, copy, and paste. Use WP all import to import data. This is the example we want to show first. To do this, use this convenient sandbox feature and select woommerce store as the presentation type. Male use the malespreadsheet to decide to batch edit woocomerce products. The price of all products over $30 will be reduced by 20% and kept for sale. To emphasize this point, I also want to temporarily change the product name to include the prefix \
Using WP all import and WP all export
Do the following: Step 1 – select the data type to export: in the word press navigation menu, click export all – > new export. In the new export screen, select the woocommerce product as the post type. As you can see from the selection list, WordPress or woocommerce can export all types of data, including data in third-party attachments or plug-ins. Step 2 – after selecting the post type to which the filter is applied, the add filter options panel appears below the post type section. The
Expand the panel and create the following simple filters: Male click the Add Rule button. In this way, WP all export will apply a filter to select only products with a price greater than 30. Our test database has 27 such products. Step 3 – click the blue custom export file button near the bottom of the select export columns screen. The drag and drop interface will be invoked. The data section is available on the right side of this interface. Expand the product data panel and drag the price and sales price fields to the column selection area. The
Now the screen must look like this: Step 4 – click the blue continue button at the bottom of the export completion screen to go to the export settings screen. Male click the green confirm and export run button on the right. Go to the OK and run screen. When the export is completed, click the blue CSV button in the click to section at the bottom of the screen. the export file. Step 5 – open the export file in a spreadsheet that likes to modify the title column. Insert a column to the right of the header column and enter the following formula in the first data row of the new column (row 2 of the spreadsheet): = \
Note that this is a Microsoft Excel formula. For other spreadsheets, it may be different. If this formula is applied, the same value as \
If this formula is applied, the selling price will be 80% of the price. Specify the format of the sales price column to 2 decimal places. Now, the two columns must be: ‹ save the spreadsheet. Step 6 – import the modified spreadsheet, click export all – > Manage export. Product exports must be displayed at the top of the list on the export management screen. In the information and Options section on the far right side of the output line, click Import with WP all import. The import process starts. On the new import screen, click file upload and select the modified product file. After uploading the file, the screen should look like this: The
Press the Continue button in step 2. Continue clicking the Continue button on all subsequent screens until the confirm and run screen appears. Here, just click the confirm green import and execute button. After the import is completed, the following confirmation must be performed: Now, if the affected products in woocommerce are confirmed, all products with a price>30 will now have a 20% discount, and the prefix \
Expand to a secondary option set. Just click Update to update this custom field, leaving the remaining fields unchanged. The edit box opens. Start typing in this edit box. A selection list is displayed. Select the \u stock field in this list. WP all imports when looking for new data or changing data Now you need to: Stage 5 – input is complete, click the blue continue button. Go to the OK and run screen. Click the \
