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
Order ID - Our internal ID for the order.
Increment ID - The customer visible order number.
Product Price Paid
Billing First Name
Billing Last Name
Billing Street Line 1
Billing Street Line 2
Billing Post Code
Shipping First Name
Shipping Last Name
Shipping Street Line 1
Shipping Street Line 2
Shipping Post Code
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
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
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):
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:
SKU - Has to be unique.
Preferably we would also get the the following data:
Tax Class (Zero Rated / Taxable Goods)
+Any product attributes, such as Size/Colour etc.
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
Schedule: Can be uploaded every X hours to compliment the products service?
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.
Stock Location - If multiple locations, a location id of where the stock is.
Last Change Date
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
Schedule: Normally daily, but could be real time as when the orders are updated in the remote system.
Order Increment ID
Courier Tracking Code
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.