Adding, updating and deleting product ribbons through import

If you have a large catalog that is difficult to update or you want to have products with the same ribbons in several Ecwid stores, you can use CSV export and import to add, update or delete your product ribbons in bulk.

You can also export/import ribbons if you want to “save” their settings: for example, the promotion in your store is over for now but you know that you might run it again in the future. In this case you can export the data, keep the downloaded file and import it back when you need it.

To add, edit or delete product ribbons in bulk:

  1. From your Ecwid admin, go to Catalog → Products.
  2. If you want to edit ribbons for all products, click Export All below your product list:

    Import1.png

    If you need to manage ribbons for particular products, you can select them in the list and then click Export Selected.
  3. Select the following columns for export – Product name, SKU, Ribbon and Ribbon color (you can choose other columns as well if you need them):

    Import2.png

  4. Click Download CSV file.
    The file will be exported with the semicolon delimiter unless you pick another delimiter (comma or tab) in the export dialog.
  5. Open the file in a plain text editor or in a spreadsheet (with the same delimiter that you’ve used for export).

    Here is, for example, how the data looks in TextEdit editor:

    Import3.png

    And this is how the same data should look in Google Sheets:

    Import4.png

  6. Add or edit the texts of your ribbons for each product in the ribbon column (they cannot contain more than 30 symbols each). To delete your product ribbons, leave the ribbon field empty.
  7. Add or edit the colors (color codes) of your ribbons for each product in the ribbonColor column. To delete your product ribbons, leave the ribbonColor field empty.
  8. Save the file.
  9. Return to Catalog → Products and click Import Products.

    Import5.png

  10. Upload your file, paying attention to the type of delimiter and the order of columns. They should be the same as in your file:

    Import6.png

After the import is complete, texts and colors of your ribbons will be updated automatically.

Was this article helpful?

Awesome! Thanks for your feedback!

Thanks for your feedback!

Sorry about that! What went wrong?
1 out of 2 found this helpful
We use cookies and similar technologies to remember your preferences, measure effectiveness of our campaigns, and analyze depersonalized data to improve performance of our site. By choosing «Accept», you consent to the use of cookies.
Accept cookies Decline