Guide

How to Add New PIM Images

The Content Person will:

  1. Make sure to standardise the image with the brand logo and optimise the file name.

    • Recommended file name format: Yuan [Herb] [Chinese Name] [English Name] [Product Type] (ex. Yuan Mugwort (艾草) Classic Soap)

    • Recommended image format: Download the template here

  2. Save the image as JPEG (not PNG especially for product images).

  3. Upload the image to the PIM folder on Google Drive (PIM > PIM YSC Assets).

The Store Manager will:

  1. Upload the image to the Shopify SG website backend (ask the SG team to do this if you're from another country).

  2. Add the new images to the PIM Gallery on Google Sites.

  3. Obtain the image link once uploaded to Shopify and paste below each image in the Gallery.

How to Import Non-English Characters in a CSV File

The Store Manager will:

  1. Export the current product database from Shopify.

  2. Rename the CSV file with this format: [Country]_Shopify_Products_[DDMMYY] (ex. SG_Shopify_Products_040221

  3. Save this as a backup file in your respective Shopify folder on Google Drive (ex. Shopify > Shopify SG > CSV Backup).

  4. Duplicate the file and make the changes on the duplicate. Follow this file name format: Import_[Country]_Shopify_Products_[DDMMYY] (ex. Import_SG_Shopify_Products_040221

  5. Key in the non-English characters (CN/VN/TH) in the CSV file. Shopify encodes non-English characters to unreadable symbols. Make sure to remove all the encoded data (ex. yuan-brightening-lotion-透亮乳) to avoid importing unwanted symbols/characters.

  6. Once done, save the file as "CSV UTF-8 (Comma delimited) (*.csv)" to ensure the non-English characters will be retained and imported to Shopify as is.

  7. Double check the information before importing. Review the pricing and inventory.

  8. Import the CSV UTF-8 file to Shopify. Tick the overwrite box.

  9. Once import is done, review the modified information on the live website to check for errors. If you spot any errors, make the corrections on the same CSV file, save as CSV UTF-8, then import back again to Shopify. Do not edit directly on the Shopify product page.

Note: Do not change the handle in the CSV file as new handles will only create duplicate files instead of overwriting the existing products. The handle is Shopify's unique ID for products.