Replacement tables are essential tools in StoreAutomator for efficiently updating product data across various channels. These tables allow you to manage product details such as title, descriptions, custom fields and more. To make bulk edits using replacement tables, follow these guidelines.
- Navigate to the "Settings" section.
- Select "Replacements" from the dropdown menu.
- Search for desired replacement table by using the search bar
- Click on edit button located below the Action column
The Replacement Editor will open, and in the upper-right corner, you'll find the Import and Export buttons.
When you click on the Export button, your replacement table will be downloaded to your computer as an Excel spreadsheet with two columns, headered 'Find' and 'Replace' .
You can make your edits in this table and then upload it back to StoreAutomator by clicking the Import button.
For example, to replace the value 'xxl' with 'XX-Large' when found, add 'xxl' to the 'Find' column and 'XX-Large' to the 'Replace' column, as shown in the image below.
Next, click the 'Import' button and drag and drop the table to the desired area to upload the table to StoreAutomator.
Once the upload process is complete, the changes you made will be reflected in the Replacement Editor. To save your modifications, use the 'Save & Close' button.