This FAQ is not anymore maintained and may contain outdated information. It will be soon removed.
We invite you to visit our new support pages at support.geekseller.com.

Integration with GeekSeller via CSV, TXT files exchange

GeekSeller is able to exchange data with other systems not via traditional EDI, but via either .csv or .txt files.

Cost: $10/mo. There is no setup fee, unless there is some very custom development needed.

 

Integration Steps

  1. The seller requests this solution and lists what data will be exchanged(qty, price, orders)
  2. GeekSeller gives the seller FTP access
  3. The seller inserts test files onto the server and notifies GeekSeller support
  4. The GeekSeller tech team checks the test files and performs checks
  5. GeekSeller activates the extension

 

 

Technical Specification

FTP address that you will connect to is ftp.geekseller.com, username and password will be provided to a seller when the integration is requested.

You will receive access to our FTP with a structure of folders as shown below (this may differ depending on the specifications of individual integrations):



File format requirement: all files should be UTF-8 encoded, CSV, comma separated. GeekSeller can generate files with other extensions (such as txt) when necessary.

 

../orders/import/

GeekSeller will upload files to this folder with new order information. Each uploaded file will have an unique name. The seller can use this file to load orders to their system. GeekSeller can customize the structure of this file to the seller's specific needs.

We submit all open orders to the FTP every few hours, so you may see duplicates. We do this just in case for some reason either your system deletes a file and fails to fetch data, or our system fails to create a file (there are many reasons this may occur, such as our server is down for few minutes or we do restart a server etc.). But as long as your system identifies orders by Order Number, it should ignore the duplicates.
 
Download samples of orders:






../orders/export/

This folder will be used by the seller's system to upload a file with tracking information for orders that have shipped. We expect sellers to upload either a CSV or TXT file here. You can download a sample file here, and see the preview below. If needed, we can adjust our script to read your file with a different structure than shown below. As you can see a file should contain at least those four columns: Order, Carrier, Service, Tracking.

 

 


../qty/

We expect the seller's system to upload to a CSV or txt file with inventory information. You should upload here only those products which qty changed within the last 24 hours. This file should have only the following columns: SKU and columns representing your nodes with the following names: "node_name Node" - you can find you node names in JET Portal or in GeekSeller on any product page. The fastest way to get your template is to login to GeekSeller and download it from Tools > Bulk Qty Update. 

One important requirement is that your system needs to upload to this folder always a file with the same name, and replace the old one if it is there.

Example of this file is shown below, you can also download it from here.

With nodes like this:



A file should look like this (please note you do not need to insert all the nodes to a file, you insert there only those that you want to update):

 

 

../price/

We expect your system to upload to this file a CSV or txt file with price information. You should upload here only those products which qty changed within the last 24 hours. This file should have only the following columns: Merchant SKU and Price columns. The fastest way to get your template is to login to GeekSeller and download it from Tools > Bulk Price Update. 

One important requirement is that your system needs to upload to this folder always a file with the same name, and replace the old one if it is there.

Example of this file is shown below, you can also download it from here.