Overview
Are you selling on a great venue that FillZ doesn't support? Do you have your own custom e-commerce site that you'd like to integrate with FillZ? Find out how below!
- We can connect to any FTP server to deposit inventory files and retrieve orders.
- FillZ allows sellers to activate up to 3 Custom Markets at no extra cost. Use of Custom Marketplaces 4 through 6 incurs a 0.1% fee surcharge per Marketplace. This fee is based on your total revenue from all non-custom sites.
Inventory File Formats
We can support inventory export files in the following formats:
- Amazon (.txt)
- BookHound
- Homebase 2.X (.txt)
- UIEE (.msg)
You can check with the marketplace directly to determine which file formats are acceptable.
Possible File Types:
You can expect the following types of export files from FillZ:
Purge Files
userid-yyyy-mm-dd-hh-mm-ss-full-purge.txt/.msg
This file contains a seller's entire active inventory. The file purges the marketplace and replaces the seller's existing inventory with the listings contained in the file.
Delta Files
Add/Modify: userid-yyyy-mm-dd-hh-mm-ss-part.txt/.msg
Delete: delete_userid-year-mm-dd-hh-mm-ss.txt/.msg
Note: These are static naming conventions for FillZ and can't be modified for Custom Marketplaces.
Frequency:
- FillZ automatically sends delta files approximately every half hour
- Purges are initiated by the seller only. We're unable to upload scheduled purge files in place of delta files.
Activation in FillZ:
1. Log in to your FillZ account and click Settings->Marketplaces->Custom Configuration for "X" (choose from Custom 1-6)
2. Enter information in all applicable text fields displayed in the screen-shot below:
- Marketplace Name = Name of the Custom Market which you are activating (eg: My Book Store)
- Hostname = Must be valid (e.g. ftp.myhostname.com). If you're unsure of the hostname, contact support at the marketplace.
- FTP User ID/Password = This may or may not be the same as the information you use to log in to your Seller Account. If you're unsure, contact support at the marketplace.
- File Format = We support Amazon - tab separated, UIEE, BookHound and Homebase.
3. Click "Save & Verify"
4. Click "Back to List"
5. Scroll down to "Configuration for Custom X," click "Activate" and then confirm the purge when prompted. We will automatically start exporting your inventory.
Configuration Notes
- We can't export to different directories; you can choose a directory on your "Marketplaces" settings page (Click "Settings" -> "Marketplaces" -> "Configuration for Custom X) by adding it to the Hostname field mentioned above. Example "FTP Hostname: ftp.bibliophile.com/books/UIEE/process". If you do not specify a directory, we will deposit inventory files in the root directory.
- Once you activate the Custom Marketplace in FillZ, our system will then begin to automatically send inventory updates to this location.
Order Retrieval
Unless you are developing your own e-commerce site or have a developer assisting you, order retrieval will need to be implemented and managed by the marketplace on which you are listing. If you are integrating your own custom site with FillZ, you will want to review the information below:
- Create a /orders directory on the server
- FillZ checks for orders in this directory every 30 to 60 minutes on average.
- Order files must be in the Term:Amazon_fulfillment_report_file_format. It is very important that the headers and content of the file match the Amazon fulfillment report exactly or the order files won't be picked up by us.
- Right-click here to download an example of the order file.
- When you are naming your files, they must follow this format or they won't be picked up by our system:
orders-2006-08-30-12-00-00.csv
"Gotchas"
This section covers details that are often overlooked when inventory/order features are being implemented:
Inventory:
Amazon-tab separated:
- Deletes can be represented by a "d" in the "add/delete" column or by "0" in the quantity column. Please ensure that you configure your system to recognize the "add/delete" header as there are occasions where a listing will be exported with a quantity greater than 0, but is meant for deletion.
- All export reports contain a dummy record that we use for debugging. The SKU in the record is always in the following format:
MARKER-yyyy-mm-dd-hh-mm-ss
This record can be ignored safely
UIEE:
- Deletes are represented by any value greater than "1" in the XB| field or by "0" in CO| field.
Orders:
- The column headers must be tab-separated, however the file must be have a .csv extension.
- "payments-date" and "purchase-date" must be in the following format or the file will not be picked up by our system:
dd-mm-yyyy hh:mm:ss
Examples:
Right:
payments-date
06-08-2007 16:33:22
Wrong:
payments-date
06-08-2007-16:33:22
Wrong:
payments-date
06-08-2007 16:33:22 EDT
- Orders for Custom Markets must be processed directly on the Marketplace. At this time, FillZ is unable to implement order confirmation for Custom Markets. If you have any questions, please do not hesitate to contact us.
|