Use Cases#

This section will cover the integration use cases & file format/configuration for carrying out these operations.

There are several ways of updating & managing campaigns via an SFTP integration; all operations can be carried out using different file formats generated by your SFTP client.

• Creating a Promotion using Single File Format
• Creating a Promotion using Double File Format (Single Vendor or Multivendor))

Creating your Promotion by using Single File Format#

• Create a CSV file including all the products that you want to create the promotion for. The file should contain
  • Product Identifier
    • SKU- string, optional field
    • Barcode- string,optional field\ - if you want to use barcodes as a product identifier, please let us know in advance about it so we can configure it in our internal tools
    • Both can be used
  • Campaign level data
    • reason- string, mandatory field
    • start_date and end_date- timestamp, mandatory field- has to be in the following format YYYY-MM-DD HH:MM:SS
    • campaign_status- boolean, optional- either 1 for active or 0 for inactive. If you are not sending the campaign status, system will assume it is ‘1’ (to enable to promotion)
    • discounted_price- double, mandatory field- final price, should be less than the original price
    • max_no_of_orders- integer, optional- the amount of orders can be placed for this campaign
    • maximum_sales_quantity- integer, optional-refers to the maximum number of units of a specific product that can be sold by a vendor or store.

Here is the example on how the file might look - In this example there are also Catalog updates included. This is discussed in more detail in the SFTP: Catalog section.

• When you have your file ready, you can push it to the Central Server to Assortment folder by using the credentials received from your Account Manager. More on this in the Credentials and Access Section.
• Check the updates in Partner Portal in Shops Integrations Section Under Single File updates. You can also download the file you have recently uploaded and review the errors if any occurred.

Creating your Promotion by using Double File Format (Single Vendor or Multivendor)#

1. Create a CSV file including all the products that you want to create the promotion for. The file should contain
   • Product Identifier
     • SKU- string, optional field
     • Barcode- string,optional field- if you want to use barcodes as a product identifier, please let us know in advance about it so we can configure it in our internal tools
     • Both can be used
   • Campaign level data
     • reason- string, mandatory field
     • start_date and end_date- timestamp, mandatory field- has to be in the following format YYYY-MM-DD HH:MM:SS
     • campaign_status- boolean, optional- either 1 for active or 0 for inactive. If you are not sending the campaign status, system will assume it is ‘1’ (to enable to promotion)
     • discounted_price- double, mandatory field- final price, should be less than the original price
     • max_no_of_orders- integer, optional- the amount of orders can be placed for this campaign
     • maximum_sales_quantity- integer, optional-refers to the maximum number of units of a specific product that can be sold by a vendor or store.

If you want to create the promotion for two or more vendors in the same file, you can use the Multivendor option. For that you can add 2 more columns to the existing file:

• vendors- in this column you can add all the vendors you want to run this promotion for separated by a comma. If you want to run the promotion for all vendors, you can simply put ‘all’ in that column.
• exclude- in order to use this column, you have to put all in the column ‘vendors’ and use the column ‘exclude’ for the vendors you want to exclude from the promotion. Separate the vendors by using commas.

2. When you have your file ready, you can push it to the Central Server to the Assortment folder by using the credentials received from your Account Manager. More on this in the Credentials and Access Section.
3. Check the updates in Partner Portal in Shops Integrations Section Under Single File updates. You can also download the file you have recently uploaded and review the errors if any occurred.