|
Now In: XML Order Import File Definition
An automated xml order import function has been added to support our large jewelry drop shippers. Since this system willl allow the automatic import of an unlimited numbers of orders from a single file download, usage of this function will incur an order surcharge to offset the cost of handling a large number of small orders. The surcharge is a function of your order volume. Please contact sales@plumislandsilver.com for details. We also have the ability to export tracking data back into your system via xml or other interfaces.
The definition of the xml file format can be found here.
The system will only run in test mode, checking the file for errors, until you are approved for full functionality. To test a file import, go to the xml order input system here.
Once your test file processes without errors, please email us the test file for approval. After verification, your account will be activated for xml order import functionality.
To use or test the xml import function click here.
Note: Payment method for all imported orders is assumed to be credit card on file.
<Root>
<Order>...
<OrderDetail>...
</Orderdetail>
<OrderDetail>...
</Orderdetail>
...
</Order>
<Order>...
<OrderDetail>...
</Orderdetail>...
<OrderDetail>
</Orderdetail>
...
</Order>
...
</Root>
The contents of the Order node are as follows:
<PONumber>required (your reference number) - limit of 20 characters</PONumber>
<Name>required for shipping address - limit of 35 characters</Name>
<Company> optional for shipping address - limit of 35 characters</Company> <Address> required for shipping address - limit of 35 characters</Address> <City> required for shipping address - limit of 20 characters</City> <State> required for shipping address - must be 2 characters</State> <Zip> required for shipping address - 5 or 10 characters</Zip> <Country> optional for shipping address - limit of 15 characters - only accepted value at this time is United States</Country> <ShippingMethod> required - accepted values are UPS GROUND,UPS SELECT 3 DAY,UPS BLUE 2 DAY,UPS RED NEXT DAY,UPS RED SATURDAY DELIVERY,FIRST CLASS MAIL,PRIORITY MAIL,EXPRESS MAIL</ShippingMethod> <Backorder> optional - either YES or NO accepted</Backorder> <Note> optional - limit of 195 characters</Note>
The contents of the OrderDetail node are as follows:
<SKU>required - limit of 15 characters - this is a Plum Island item numer (see example file below)</SKU>
<Quantity>required - number between 1 and 999</Quantity>
Here is an example file:
<Root>
<Order>
<PONumber>12356</PONumber>
<Name>Jane White</Name>
<Address>1 Main St</Address>
<City>Cityville</City>
<State>MN</State>
<Zip>12345</Zip>
<Country>United States</Country>
<ShippingMethod>UPS GROUND</ShippingMethod>
<Backorder>YES</Backorder>
<Note>Ship silver jewelry soon please!</Note>
<OrderDetail><SKU>EP-055</SKU><Quantity>1</Quantity></OrderDetail>
<OrderDetail><SKU>BR-1</SKU><Quantity>2</Quantity></OrderDetail>
</Order>
<Order>
<PONumber>12370</PONumber>
<Name>Sue White</Name>
<Company>-</Company>
<Address>1 Main St</Address>
<City>Cityville</City>
<State>MN</State>
<Zip>12345</Zip>
<ShippingMethod>FIRST CLASS MAIL</ShippingMethod>
<Backorder>YES</Backorder>
<Note>Wholesale Silver Jewelry Order</Note>
<OrderDetail><SKU>EP-54</SKU><Quantity>3</Quantity></OrderDetail>
<OrderDetail><SKU>NK-101</SKU><Quantity>4</Quantity></OrderDetail>
</Order>
<Order>
<PONumber>12371</PONumber>
<Name>Bill White</Name>
<Company>-</Company>
<Address>1 Main St</Address>
<City>Cityville</City>
<State>MN</State>
<Zip>12345</Zip>
<Country>United States</Country>
<ShippingMethod>PRIORITY MAIL</ShippingMethod>
<OrderDetail><SKU>SR-1/05</SKU><Quantity>10</Quantity></OrderDetail>
<OrderDetail><SKU>BOX-019-18</SKU><Quantity>20</Quantity></OrderDetail>
</Order>
</Root>
| 
