Welcome to AB Commerce, your Analytics-Based eCommerce Platform that sits on top of your ERP/ePos system so that you can manage your website from your ERP/ePos system.
What does this mean?
- New products added to your ERP/ePos system can be 'Activated for web' and these new products will be transferred over to your website within 30 minutes.
- When making Price Updates, you can update the price in your ERP/ePos and the price will be automatically updated on the website.
- Stock levels are transferred from your ERP/ePos to your website so that your stock control is enabled on the website.
- Any many other benefits.
How does it work?
- Downloading Orders – Every 15 minutes, you call a real-time web service that downloads the latest web orders into your ERP/ePos and then a 2nd web service that updates each order’s status from NEW ORDER to ORDER DOWNLOADED.
- Uploading Data – Either directly after you download the orders every 15 minutes and have updated the stock levels with these new web orders OR at a less regular schedule like once per hour or once a day during the night, you upload a set of CSV files to our FTP server. The list of csv files that you can send us are listed below and include the products file and the stock file.
- Optional Real-time Stock Updates - While the above web services and csv files may be relatively easy to implement and include maintaining stock levels, there is an optional real-time stock updates web service which you can call at any time to update the stock levels on the website. This can be more complicated to implement than just sending us stock levels through csv files but allows for more real-time stock accuracy.
Main CSV files that you can export
The following are the main CSV files that you can export:
CSV File |
|
|
Products |
products_YYYYMMDDHHMMSS.csv (e.g. products_20180108172804.csv) |
Only send products ENABLED FOR WEB
Every 15 minutes |
Product Category Relationships |
prodcats_YYYYMMDDHHMMSS.csv |
Only send products ENABLED FOR WEB
Every 15 minutes |
OPTIONAL: Related Products |
relatedproducts_YYYYMMDDHHMMSS.csv |
Only send products ENABLED FOR WEB
Every 15 minutes |
Stock Levels |
stock_YYYYMMDDHHMMSS.csv |
Sent once a day during the night with all stock levels (e.g. 3:00am) |
Stock Changes |
stock_YYYYMMDDHHMMSS_DELTA.csv |
If sending stock changes throughout the day, send this file every 15 minutes with just the products that have stock changes |
Optional CSV files that you can export
The following are additional optional CSV files that you can export:
CSV File |
Description |
Filename Format |
Outlet Stock Levels |
All product stock levels for each outlet |
outletstock_YYYYMMDDHHMMSS.csv outletstock_YYYYMMDDHHMMSS_DELTA.csv |
Price Plans |
All price plans that contain groups of products |
priceplans_YYYYMMDDHHMMSS.csv |
Price Plan Prices |
All prices for the price plans above |
priceplanprices_YYYYMMDDHHMMSS.csv |
Customers |
All customers marked as “Active for Web” |
customers_YYYYMMDDHHMMSS.csv |
Customer Price Plans |
All price plans that each customer is on |
customerpriceplans_YYYYMMDDHHMMSS.csv |
Orders |
All offline sales + processed web sales |
orders_YYYYMMDDHHMMSS.csv |
Order Line Items |
All line items for the sales above |
orderitems_YYYYMMDDHHMMSS.csv |
Comments
0 comments
Please sign in to leave a comment.