Integration Import Export Fields

Export (from us):
  • Order Data
    • 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.
Comments