America's Favorite Sterling Silver Jeweler
SUBSCRIBE TO OUR EMAIL LIST
You have 0 item(s) in your Shopping Cart Checkout
Holiday Sale
An automated xml order import function has been added to support our large jewelry drop shippers.
 
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.
 
The format of the xml order import file must adhere to the following node structure:
 
<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>
 
BACK TO TOP OF PAGE