How to Integrate#

This section covers the basics of how to integrate. Click these links below to access each section of the integration process as required, or simply scroll down the page:

• Integration prerequisites
• Credential management & access
• File format(s) configurations and limitations

Integration prerequisites#

To successfully integrate Promotions via SFTP, the following requirements must be met:

1. Onboarding to the Local Shops product stack, including:

   1. Access to the Partner Portal
   2. Access to the Integrations Plugin within the Partner Portal

2. External Vendor ID Configuration: If using your own vendor IDs, ensure they are correctly configured.

3. Active Catalog: Items must be successfully associated between our item catalog and vendors in your chain

4. Valid Credentials: Necessary for accessing our SFTP Central Server. Please request valid credentials from your Account Manager

5. SFTP Client: Must be capable of pushing CSV files in the specified format, detailed in the ‘File Format section’

Credentials and Access to foodpanda’s Server#

1. Access an FTP Application/ Software
   • Have access to an FTP Application/ Software (e.g Filezilla) that will allow you to access foodpanda’s Server.
2. Host URL:
   • In the FTP Application you will need to enter: vendor-automation-sftp-live-ap.prod.aws.qcommerce.live
3. Credentials:
   • User Name
   • Password

4. Port (communication endpoint) which is always 22, no matter on what chain you are accessing.

File format(s) configurations and limitations#

As you introduced before, there are 3 types of file formats you can adopt.
Below you can learn about configuring each and details about their capabilities and limitations.

• Single File Format for Single Vendor
• Double File Format for Single Vendor
• Double File Format for Multi Vendor

Compliance with at least one of the available file formats as described below is required for a fully-functional SFTP integration To enable proper synchronization, files must follow specific naming conventions:

Single File Format#

• Both the Assortment & Promotions updates are sent in a single file
  • This format is designed to update the assortment and/or promotions for a single vendor or store at a time. However, multiple promotions for the same vendor or store can be included, allowing you to create promotions for different dates within a single file.
    • The update file must be pushed into the Assortment sub-directory.
• File naming pattern: <prefix>_<vendor_id>.csv
  • The prefix can be any chosen value.
  • The vendor_id refers to either the External Vendor ID defined in the Partner Portal or the Platform Vendor ID if no External Vendor ID is configured.
• File processing time: max. 50 minutes.
• Limitations :
  • Row Limit (rows in the file) : 20K
  • SKU Limit for each campaign : 19,999
  • Max number of Products (SKU x Vendors ) : N/A
  • Max File Size : 200MB
  • Promotions count: 1000 in one file (promotions with different dates)
• Format example :

Double File Format for Single Vendor#

• Assortment and Promotions updates are submitted in two separate files.

  • This format is designed to update promotions for a single vendor or store at a time. However, multiple promotions for the same vendor or store can be included, allowing you to create promotions for different dates within a single file.
    • The update file for Assortment must be uploaded to the Promotions sub-directory.
  • File naming pattern: <prefix>_<vendor_id>.csv
    • The prefix can be any chosen value
    • The vendor_id refers to either the External Vendor ID defined in the Partner Portal or the Platform Vendor ID if no External Vendor ID is configured.

• File processing time: max. 50 minutes

• Limitations:

  • Row Limit (inclusive of column header) : 20K
  • SKU Limit : 19,999
  • Max File Size : 200MB
  • Promotions count: 1000 in one file (promotions with different dates)

• Format example :

Double File Format for Multi Vendor#

• Assortment and Promotions updates are submitted in two separate files.
  • This format is designed to update the assortment for multiple vendors or stores within a single file.
  • The update file for Promotions must be uploaded to the Promotions sub-directory.
    • File naming pattern : <prefix>.csv, file name should not have any underscore, for example : Testchain.csv
• File processing time: max. 90 minutes
• Limitations:
  • Row Limit (inclusive of column header) : 20K
  • SKU Limit : 99,999
  • Max number of Products (SKU x Vendors) : 300K
  • Max File Size : 200MB
  • Promotions count: 1000 in one file (promotions with different dates)
• Format example: