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 catalog updates 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

      1. The above is default for all partners using our platform. If you have any issues with access to our plugins, please contact your AM

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

Single File Format#

• Assortment & Promotions update is pushed in one file.

• This format is intended to update assortment and/or promotions for a single store at one time.

• The update file must be pushed into the Assortment sub-directory.

• File naming pattern: <prefix>_<vendor_id>.csv, where prefix can be anything and vendor_id is the External vendor id defined in the Partner Portal or Platform vendor id if it’s not configured.

• File processing time: max. 15 minutes if the file contains only assortment updates (no promotions update). If the file contains both assortment and promotions data - the update will take a maximum of 50 minutes.

• Limitations:

  • Row Limit (inclusive of column header) : Up to 100K including promotions

  • SKU Limit : 99,999

  • Max number of Products (SKU x Vendors ) : N/A

  • Max File Size : 200MB

• Format example :

Double File Format for Single Vendor#

• Assortment & Promotions update is pushed in two different files.

• This format is intended to update the assortment for a single vendor/store at a time.

• Update file for Assortment must be pushed into the Catalog sub-directory

• Update file for Promotions must be pushed into the Promotion sub-directory

• File naming pattern: <prefix>_<vendor_id>.csv, where prefix can be anything and vendor_id is the External vendor id defined in Partner Portal or Platform vendor id if it’s not configured.

• File processing time :

  • Maximum 15 minutes for Catalog files

• Limitations:

  • Row Limit (inclusive of column header) : 1.5 Million

  • Max File Size : 200MB

• Format example for Catalog Update:

Double File Format for Multi Vendor#

• Assortment & Promotions update is pushed in two different files.

• This format is intended to update the assortment for more than one vendor/store in one file.

• Update file for Assortment must be pushed into the Catalog sub-directory

• Update file for Promotions must be pushed into the Promotion sub-directory

• File naming pattern: <prefix>.csv, file name should not have any underscore, for example : Testchain.csv

• File processing time:

  • Maximum 15 minutes for Catalog files

  • Maximum 50 minutes for Promotions files

• Limitations for Catalog files:

  • Row Limit (inclusive of column header) : 1.5 Million

  • Max File Size : 200MB

• Format example for multivendor Catalog Update: