In Store Pickup Scope

The In Store Pickup (ISP) is a functionality in eBay allowing for its buyers to chose a specific store near them where they want to pick the item from instead of having a standard home delivery. This is a functionality that needs to be specifically allowed for the sellers and is generally rare.

The way it works in a few quick words is that we upload a list of the sellers stores to create them as locations and then we populate quantity in those locations for different SKUs. Once an order is placed for a store we can identify this by an additional section in the orders XML. Finally update for the orders are done in a specific way updating with special statuses for the order to be Ready for pickup, Picked up, Pickup cancelled, Returned.

Good read for the ISP: https://pages.ebay.com/instorepickup/

API documentation: http://developer.ebay.com/DevZone/store-pickup/Concepts/InStorePickupGuide.html

Products

To incorporate the Products section for ISP in our software we need to go through the following steps:

1. Standard Products Add/Revise - to allow for a product to be participating in the ISP program we need to allow that with a simple Boolean value. This is to be additional flag in the item_account_ebay table so it can be operated if it should be on or off. The field should be with a default value of 0 (NO)
2. Retail Store Locations - a new separate table needs to be created for holding all necessary information for the communication with eBay. Besides the eBay required fields we are to have 3 of our own. Status, communication flag (to mark whenever a change has occurred and it needs to be sent to eBay) and Location connection (for connecting a retail store to a warehouse location in our software).
3. Stock Updates - storing quantities against their respective locations will give us the option to automatically check on next read any changes and those that have changed to be send (or prepared for sending) to eBay.

Orders

To incorporate the Orders section for ISP in our software we need to go through the following steps:

1. Identifying orders as ISP - in the standard getOrders call we are to start reading for the relevant ISP section. Whenever found this is to stored in the orders_ebay table in relevant fields. Additionally a "type" field is to be introduced to orders with 3 values - Home Delivery / Click & Collect / In Store Pickup. For the ISP orders we will need to mark the orders as such so they can be easily identified
2. Update ISP orders -