We are after a database and tool to manage our orders.
We are reselling items from Amazon on eBay. We are currently using Magento to keep track of all of our orders and shipping despatch as well as accounting purposes.
- Ability to add Amazon products in our database / application Using Amazon URL or ASIN (E.G.) : http://www.amazon.co.uk/gp/product/B00CPLENJQ/ref=s9_simh_gw_p63_d0_i3?pf_rd_m=A3P5ROKL5A1OLE&pf_rd_s=center-2&pf_rd_r=0BEZT0B5JGGW8Y9HC0YF&pf_rd_t=101&pf_rd_p=418448347&pf_rd_i=468294
All important information uploaded into application such as price, eBayPrice, Competitor Price, Salesrank,(please see http://www.sellermarketplace.com/tour.html this is similar interface to what we would like)
The price will be updated from Amazon on an example: 3 hourly basis and whether the item is "Fulfilled by Amazon" or not needs to be updated.
Prices, Quantity's, Titles need to be able to be updated in near realtime or batch job.
We would like to have Calculation of Profit Margins for sales on Ebay minus the fees and PayPal fees and Category fees (10% Normal items, 9% Media,
5% Electronics) as we will be drop-shipping and fulfilling our items from Amazon onto eBay.
Feature to Automatically list Amazon product onto our eBay account(s) including Title, Multiple Pictures, Features & Description into a description template for eBay.
(Category id, sell price would be provided - see http://www.sellermarketplace.com/tour.html for example)
Feature to automatically associate eBay order with related Amazon order (that way we can automatically import tracking reference once item is shipped by Amazon & be able to track PayPal transactions in case of refunds etc. -
currently Magento tracks the PayPal payments on eBay orders and gives us the link to the PayPal payment information)
Automatically order item from Amazon and send to customer with their chosen shipping format (next day, international or standard) - Some exceptions will be required if some manual intervention is required. Once order is complete it is associated to the ebay transaction.
- Ability to price match or beat competitors - again see PriceSpectre for this or if you cannot do we can continue to use PriceSpectre if not possible.
- eBay Order inside the application, with Buy Price (from Amazon) and sell Price (from eBay) along with our profit margin and all important historical information.
Many more features required once complete.
I'm sure more explanation will be required on some point and will be happy to discuss further if clarification is needed.