You can import store pickup orders via Magento or API. For Magento you just need to have WeSupply Toolbox installed.
For an example store pickup order import via API, check below:
Note: ItemPOShipper must be "In Store Pickup" and ItemLevelSupplierName must be a ClientKey from your store details CSV.
Store Pickup Order XML example:
<Orders>
<Order>
<OrderDate>2021-03-11 05:37:39</OrderDate>
<LastModifiedDate>2021-03-11 05:49:56</LastModifiedDate>
<StoreID>1</StoreID>
<OrderModified>2021-03-11 13:49:56</OrderModified>
<OrderPaymentTypeID>1</OrderPaymentTypeID>
<OrderID>mage_300</OrderID>
<OrderNumber>300</OrderNumber>
<FirstName>Iulius Mall</FirstName>
<LastName>Store</LastName>
<OrderContact>Iulius Mall Store</OrderContact>
<OrderAmount>1390.0000</OrderAmount>
<OrderAmountShipping>119.9100</OrderAmountShipping>
<OrderAmountTax>0.0000</OrderAmountTax>
<OrderAmountTotal>1371.9100</OrderAmountTotal>
<OrderAmountCoupon>0.0000</OrderAmountCoupon>
<OrderAmountGiftCard>0.0000</OrderAmountGiftCard>
<OrderShippingAddress1>Oksoktaruk Blvd</OrderShippingAddress1>
<OrderShippingCity>White Mountain</OrderShippingCity>
<OrderShippingStateProvince>Alaska</OrderShippingStateProvince>
<OrderShippingZip>99784</OrderShippingZip>
<OrderShippingPhone>0123456789</OrderShippingPhone>
<OrderShippingCountry>United States</OrderShippingCountry>
<OrderShippingCountryCode>US</OrderShippingCountryCode>
<OrderPaymentType>Credit Card (Braintree)</OrderPaymentType>
<OrderDiscountDetailsTotal>-138.0000</OrderDiscountDetailsTotal>
<OrderExternalOrderID>300</OrderExternalOrderID>
<CurrencyCode>USD</CurrencyCode>
<OrderStatus>Pending</OrderStatus>
<OrderStatusId>2</OrderStatusId>
<OrderCustomer>
<CustomerName>John Doe</CustomerName>
<IsGuest>0</IsGuest>
<CustomerID>2</CustomerID>
<CustomerFirstName>John</CustomerFirstName>
<CustomerLastName>Doe</CustomerLastName>
<CustomerPostalCode>11205</CustomerPostalCode>
<CustomerEmail>john.doe@teststore.com</CustomerEmail>
<CustomerCreateDate>2021-03-11 05:37:39</CustomerCreateDate>
<CustomerModifiedDate>2021-03-11 05:49:56</CustomerModifiedDate>
<CustomerAddress1>Oksoktaruk Blvd</CustomerAddress1>
<CustomerAddress2></CustomerAddress2>
<CustomerCity>White Mountain</CustomerCity>
<CustomerCountry>United States</CustomerCountry>
<CustomerCountryCode>US</CustomerCountryCode>
<CustomerPhone>0123456789</CustomerPhone>
<CustomerStateProvince>Alaska</CustomerStateProvince>
<CustomerShippingAddresses>
<CustomerShippingAddress>
<AddressID>13</AddressID>
<AddressContact>Iulius Mall Store</AddressContact>
<AddressAddress1>Oksoktaruk Blvd</AddressAddress1>
<AddressCity>White Mountain</AddressCity>
<AddressState>Alaska</AddressState>
<AddressZip>99784</AddressZip>
<AddressCountry>United States</AddressCountry>
<AddressCountryCode>US</AddressCountryCode>
<AddressPhone>0123456789</AddressPhone>
</CustomerShippingAddress>
</CustomerShippingAddresses>
</OrderCustomer>
<OrderItems>
<Item>
<ItemID>24</ItemID>
<ItemPrice>69.0000</ItemPrice>
<ItemAddressID>13</ItemAddressID>
<Option1></Option1>
<Option2>
<Size>XS</Size>
<Color>Black</Color>
</Option2>
<Option3></Option3>
<ItemProduct>
<ProductID>1370</ProductID>
<ProductCode>Neve Studio Dance Jacket</ProductCode>
<ProductPartNo>WJ11-XS-Black</ProductPartNo>
</ItemProduct>
<ItemTitle>Neve Studio Dance Jacket</ItemTitle>
<ItemImageUri>https//www.petstore.com/pub/media/catalog/product/w/j/wj11-black_main_1.jpg</ItemImageUri>
<ItemQuantity>10</ItemQuantity>
<ItemShippingService></ItemShippingService>
<ItemPOShipper>In Store Pickup</ItemPOShipper>
<ItemShippingTracking></ItemShippingTracking>
<ItemLevelSupplierName>store_15</ItemLevelSupplierName>
<ItemTotal>345.0000</ItemTotal>
<ItemTax>0.0000</ItemTax>
<ItemDiscountDetailsTotal>69.0000</ItemDiscountDetailsTotal>
<ItemStatus>Processing</ItemStatus>
<ItemStatusId>4</ItemStatusId>
<ItemShipping>119.9100</ItemShipping>
<ItemLength>12</ItemLength>
<ItemWidth>10</ItemWidth>
<ItemHeight>10</ItemHeight>
<ItemMeasureUnit>in</ItemMeasureUnit>
<ItemWeight>1.0000</ItemWeight>
<ItemWeightUnit>lb</ItemWeightUnit>
<Item_CouponAmount>0.0000</Item_CouponAmount>
<PickupUTCTimestamp>1587653473</PickupUTCTimestamp>
<PickupUTCOffset>+10800</PickupUTCOffset>
</Item>
<Item>
<ItemID>25</ItemID>
<ItemPrice>70.0000</ItemPrice>
<ItemAddressID>13</ItemAddressID>
<Option1></Option1>
<Option2>
<Size>L</Size>
<Color>White</Color>
</Option2>
<Option3></Option3>
<ItemProduct>
<ProductID>1371</ProductID>
<ProductCode>Juno Jacket</ProductCode>
<ProductPartNo>WJ12-L-White</ProductPartNo>
</ItemProduct>
<ItemTitle>Juno Jacket</ItemTitle>
<ItemImageUri>https//www.petstore.com/pub/media/catalog/product/w/j/wj12-white_main_1.jpg</ItemImageUri>
<ItemQuantity>10</ItemQuantity>
<ItemShippingService></ItemShippingService>
<ItemPOShipper>In Store Pickup</ItemPOShipper>
<ItemShippingTracking></ItemShippingTracking>
<ItemLevelSupplierName>store_15</ItemLevelSupplierName>
<ItemTotal>700.0000</ItemTotal>
<ItemTax>0.0000</ItemTax>
<ItemDiscountDetailsTotal>69.0000</ItemDiscountDetailsTotal>
<ItemStatus>Processing</ItemStatus>
<ItemStatusId>4</ItemStatusId>
<ItemShipping>119.9100</ItemShipping>
<ItemLength>12</ItemLength>
<ItemWidth>10</ItemWidth>
<ItemHeight>10</ItemHeight>
<ItemMeasureUnit>in</ItemMeasureUnit>
<ItemWeight>1.0000</ItemWeight>
<ItemWeightUnit>lb</ItemWeightUnit>
<Item_CouponAmount>0.0000</Item_CouponAmount>
<PickupUTCTimestamp>1587653473</PickupUTCTimestamp>
<PickupUTCOffset>+10800</PickupUTCOffset>
</Item>
</OrderItems>
</Order>
</Orders>
For details about how to update your Pickup Order status , check our article How to update In-Store Pickup Orders in WeSupply
Comments
0 comments
Please sign in to leave a comment.