Vendors
      Back to home
      1. Corporategift.com knowledge base
      2. Integrations
      3. Vendors

      Corporategift.com SFTP/CSV integration Instructions

      Vendors' instructions on how to integrate orders, shipping tracking, and inventory using SFTP/CSV

      Instructions for Sellers

      The level of integration is up to the seller’s comfort. Option A is an inventory feed, option B is the order transaction automation. The seller may choose to do either option A, option B or both; however, for seamless order processing and smooth communication between systems, we recommend sellers participate in both options. Please see below for further instructions.

      SFTP address: 

      HOST: 44.195.186.45

      PORT: 22

      Login: In the body of the email 

      Password:In the body of the email

      I'm attaching 4 files:

      3 files to go into the outbox directory (Seller can do either A or B or both):

      1. A) Inventory

      INVENTORY_2022-03-03.csv  (date and time need to change in the file name)

      inventory updates, (we pull every 1 hr) 

      contain the following fields:

      • Item SKU (variant part id)
      • Quantity

      Item SKU represents your internal SKU and quantity is the available inventory.

      1. B) Orders/Transacting

      SHIP_CONFIRM_2022-03-03.csv  (date and time need to change in the file name)

      Representing - confirmation that the order is shipped and we have tracking separated by this character |

      CSV file will contain the following fields:

      • Order Number - Seller internal order id
      • Po Number - CG order number
      • Item SKU - Seller item SKU(variant part id)
      • Quantity (how many units are ordered)
      • Shipping method (eg ground, 2 days, overnight)
      • Carrier code(eg FedEx, UPS)
      • Tracking code (eg Tracking number) 

      ACK_2022-03-03.csv (date and time are in the file name)

      Representing - confirmation that you got the order

      Must contain the following fields:

      • Order Number - Seller internal order id. 
        • If order cannot be processed (eg rejected) “Seller internal order id” must be set to “REJECTED” 
      • PO Number - CG order number
      • Note - Any pertinent info related to this order (eg out of stock, rejected, item id invalid, shipping delay)

      One file goes into the Outbox directory CG upload once an hour:

      PO_10182022152014.csv (date time is changing) 

      Representing - new orders from the last one hour

      CG sends the following fields (Note: each order line item is sent in a separate row; one order may have multiple rows):

      • PONumber - CG order number
      • OrderDate - Order Date
      • ShipMethod - (Ground, 2 Day or Overnight)
      • ShipDate - (if need to be shipped in a later date)
      • FirstName - ship to first name
      • LastName - ship to last name
      • Company - ship to company name
      • Street1 - ship to address1
      • Street2 - ship to address1 (where applicable)
      • City - ship to city
      • State - ship to state
      • PostalCode - ship to zip code
      • Phone - ship to the phone number
      • ItemSKU - Seller item SKU (variant part id)
      • Qty - qty
      • UnitPrice - CG unit cost
      • GiftMsgLine1 - greeting card message (we separate to 30 characters so if its longer it will be split to the next column)
      • GiftMsgLine2 - longer gift message #2
      • GiftMsgLine3 - longer gift message #3
      • GiftMsgLine4 - longer gift message #4
      • GiftMsgLine5 - longer gift message #5
      • GiftMsgLine6 - longer gift message #6 (this will continue until the message is completed)