Create a Promotion With a CSV File

Wish built the Merchant Promotions Platform (Merchant Dashboard > Promotions) as a tool to create and expand promotion offerings. The CSV file option for creating promotions allows you to quickly bulk upload the products you want to include in your promotion. 

If you are new to merchant promotions and/or the platform, please first read the following Help Center articles to learn how promotions work:

• Merchant Promotions Overview (includes information on manually building a promotion)
• Merchant Promotions Platform FAQs

If you are ready to create a promotion, and you know you want to do so via a CSV file, please continue reading the instructions below.

---------------------------------

---------------------------------

Download Eligible Products

Once you decide to create a promotion via CSV file, you should first request a list of promotion-eligible products by going to the Merchant Dashboard > Promotions > Merchant Promotions > Request CSV for Eligible Products for Promotion (receipt takes less than 24 hours).

Note that you must know the type of promotion (i.e., Discount, Flash Sale, Event) you plan to run prior to submitting the request. You can learn more about promotion types, their eligibility requirements, and how they differ by reading the article, “Promotion Requirements and Rejections.”

Get Started

After pulling together your CSV file of eligible promotion products , return to the Merchant Dashboard > Promotions > Merchant Promotions > Merchant Promotions Home to Create a Promotion > Upload via CSV. 

Upload via CSV

Follow the prompts  in each step to 1) Choose Promotion Type, 2) (Enter) Promotion Details, 3) Upload Your Formatted CSV File, 4) Review Promotion

A few note/tips while working through these steps:

• Check dates to make sure your product(s) are not in conflicting events.
• Check that your product(s) comply with regional restrictions.  
• Check that the minimum discount applies to your products and meets promotion requirements.
• "Promotion Details" differ depending on the promotion type (i.e., Discount/Flash Sale require you populate promotion details, whereas Event details are pre-populated).
  • Promotion Name (required for Discount and Flash Sale) helps you to differentiate and keep track of each promotion; it is not customer facing. 
  • Start and End Date vs. Preferred Week options work as follows:
    • Discount promotions span days, so it allows a date range to be chosen. (Date and time ranges are in Pacific Time.)
    • Flash Sale promotions run for limited hours, so you choose a preferred week, and Wish optimizes the best day and time of your chosen week to run the Flash Sale. This helps to ensure that your Flash Sale runs at the most advantageous time (i.e., when there is likely to be the most user traffic) and helps to avoid multiple Flash Sale promotions running simultaneously. Wish provides the optimized run time of the promotion upon approval of the promotion. 
• “Countries” default to all of the countries you sell to, and promotions can be targeted by selecting or deselecting a country. (At least one country must be chosen to proceed with building the promotion.) This section can be edited during the promotion creation process, but countries cannot be edited once the promotion is submitted.

When you reach Step 3: Upload Your Formatted CSV File, the platform provides an example for how to format a CSV file as well as a template to download. (If you requested a CSV for eligible products for promotion, then you should be able to use that file.)

Promotion columns include:

• Product ID
• Product Name
• Variation ID - Required; there can be multiple Variation IDs for one Product ID
• Variation Name
• Discount % off - The % discount applies to the total price (product price + shipping price).
• Quantity

Example:

Take time for Step 4: Review Promotion and ensure the right products, product variations, percentage discounts, and quantity are submitted.

• Click the chevron symbol at left (under Product/Variation ID) to view product variations.
• Quantity set for each product must adhere to the promotion’s eligibility requirements. If the CSV file Quantity field is incorrectly populated or does not align with the Merchant Promotions Platform inventory, it can have varying results when displayed in the Merchant Promotions Platform:

• • Rejected products, found under the product list, are products that do not meet the promotions eligibility requirements. Any rejection should list the product's "Rejection Reason" with more information so you can potentially fix the issue.
    • To fix rejected products, or anything found to have uploaded incorrectly, you must go back to the CSV file, update the rejected data or remove the product altogether, and then repeat, “Upload your formatted CSV file.”

  Click Submit Promotion once everything is confirmed as correct and complete. After submitting a promotion, it can take up to 24 hours for Wish approval. During that time, promotions live in the Pending Promotion tab on the Promotions landing page.

  To learn more about the Pending Promotion tab, Active Promotions tab, History tab, how to view promotion details and performance, modify/cancel a promotion, and more, please visit, “Merchant Promotions Overview”