Overview: Orders exported in realtime into a folder on the server ready to be collected.
Colour Key: Order Info / Payment Info / Product Info / Customer Info / Billing Info / Shipping Info
Fields:
Order ID - Our internal ID for the order.
Increment ID - The customer visible order number.
Shipping Method
Tax Rate
Tax Amount
Grand Total
Discount Code
Discount Amount
Currency
Shipping Amount
Gift Message
Message Text
Payment Method
Payment Amount
Product ID
Product SKU
Product Price
Product Price Paid
Quantity
Line Total
Customer ID
Email
Prefix
First Name
Last Name
Billing First Name
Billing Last Name
Billing Street Line 1
Billing Street Line 2
Billing City
Billing Region
Billing Post Code
Billing Country
Billing Telephone
Shipping First Name
Shipping Last Name
Shipping Street Line 1
Shipping Street Line 2
Shipping City
Shipping Region
Shipping Post Code
Shipping Country
Shipping Telephone
Customer Data
Overview: A customer file could be generated on each amend to the customer account or to accompany the orders service.
Colour Key: Customer Info / Billing Info / Shipping Info
Fields:
Customer ID
Email
Prefix
First Name
Last Name
Default Billing First Name
Default Billing Last Name
Default Billing Street Line 1
Default Billing Street Line 2
Default Billing City
Default Billing Region
Default Billing Post Code
Default Billing Country
Default Billing Telephone
Default Shipping First Name
Default Shipping Last Name
Default Shipping Street Line 1
Default Shipping Street Line 2
Default Shipping City
Default Shipping Region
Default Shipping Post Code
Default Shipping Country
Default Shipping Telephone
Returns Data
Overview:
This is normally a replica of the orders service, with a different file
name and order numbers normally prefixed with an R, but can be tailored
or turned off to suit.
Import (to us):
Products/Items
Overview:
Schedule: Normally daily, but could be more often if
Fields: We're open to as much data for products/items as we can out of the remote system, however as a minimum we would require:
Name
SKU - Has to be unique.
Description
Price
Preferably we would also get the the following data:
Weight
Short Description
Product Images
Barcode
Tax Class (Zero Rated / Taxable Goods)
+Any product attributes, such as Size/Colour etc.
Categories
Overview:
The file would need to contain the category and product assignment
data. I have included the filed "Children" as hopefully via XML the
child categories can contain the same field set but in a child block of
the parent.
Schedule: Can be uploaded every X hours to compliment the products service?
Fields:
Category Name
Category Description
Product ID's
Children
Stock Levels
Overview:
The most frequent of services to run. The file can either contain
everything or just the stock that has changed, or everything with a
timestamp of the last change (the we can choose what to import).
Schedule: Normally multiple times per hour (every 15mins etc.) No faster than once a minute.
Fields:
Product SKU
Stock Level
Stock Location - If multiple locations, a location id of where the stock is.
Last Change Date
Order Updates
Overview:
We can automate the update of order in the Magento system when they are
dispatched from the remote system. If there is a potential for partial
or split shipments we would also need the product ids/data on a per
shipment basis.
Schedule: Normally daily, but could be real time as when the orders are updated in the remote system.
Fields:
Order Increment ID
Order ID
Courier
Courier Tracking Code
Customer Updates
Overview: This would be needed if the client wanted to
completely synchronise the customer with the data in the remote system.
We would need a file that matches the customer export file above
when/if the customer is changed/updated in the remote system.