When your product data (such as prices, descriptions, or dimensions) changes, it's important to update AMP to reflect these modifications. AMP offers several methods for updating product data efficiently, whether you’re working directly in the system or using an external file like Excel.
To Update Product Data Quickly in AMP:
Navigate to the Product Table:
- Go to Manage Catalog > Products from the AMP CMS.
Edit the Product Table:
- Select the product table file you wish to update.
- Click Edit Table in the table editing bar.
Make Your Changes:
- Edit the product data directly in the table (e.g., update prices, descriptions, dimensions, etc.).
- Once finished, click the save button to save your changes.
To Update Product Data in AMP from Excel:
Export Your Product Table:
- Go to Manage Catalog > Products from the AMP CMS.
- Select the product table file you want to update.
- Click Export to CSV from the table editing bar to download the data.
- Open the exported CSV file in Excel.
- Make the necessary changes to your product data (e.g., updating prices, descriptions, or inventory).
- Save the file as a CSV.
Upload the Updated CSV:
- Return to the AMP CMS and click Choose File from the table editing bar.
- Select the CSV file you just edited from your computer.
Review and Accept the Upload:
- Click Upload updated file.
- Review the changes and click Accept the upload to finalize the update.
Pro Tip:
- Updating via Merge: If you have a separate file containing only the changes (rather than exporting the entire table), you can upload just that file. AMP will merge the updates, meaning:
- Existing SKUs/Product IDs in the file will be updated with new data.
- New SKUs/Product IDs will be added.
- Missing SKUs/Product IDs or fields will be ignored, so there's no risk of overwriting data that doesn't need to change.
To Update Product Data Manually in AMP:
Navigate to the Product Table:
- Go to Manage Catalog > Products from the AMP CMS.
Select the SKU to Edit:
- Open the product table file and click on the blue SKU/Product ID you wish to update.
- Open the product table file and click on the blue SKU/Product ID you wish to update.
Edit the Product Data:
- Make changes to the product details directly on the SKU/Product page (e.g., change price, description, or dimensions).
Submit Your Changes:
- Click Submit to save your updates.
- Click Submit to save your updates.
Additional Update Options:
- API Integration: Product data can also be updated automatically via an API connection. For more information on setting up API connections, contact api@amptab.com.
- QuickBooks Connector: If you're using QuickBooks, you can also set up a connector to update product data. Contact api@amptab.com for assistance with integration.
By following these steps, you can easily keep your product data up to date in AMP, ensuring your catalog is always accurate and reflects any changes in your inventory or product details.
If you need help or have questions, feel free to contact support@amptab.com!