API to integrate USPS, Ebay, Amazon and E-Junkie with MS Access
$90-150 USD
キャンセル
投稿日: 11年近く前
$90-150 USD
完了時にお支払い
Specs:
The user is an online merchant, selling with ebay, Amazon and e-junkie. The user processes data with MS Access tables, forms, macros, queries, reports...
The user ships most product with USPS (USA Postal), integrating with [login to view URL] as the portal to batch export/import the shipping data i.e. shipping address, tracking# and to also print postage stamps and shipping labels.
I need a VBA MS Access developer to make 4 different Access macros:
1. Make an Access macro called "macro_import_from_order_source_data", that would run an API to import new customer-order data from the order sources Ebay, Amazon and e-junkie. The order data would be appended to the tables, "tbl_ebay", "tbl_E-junkie" and "tbl_amazon" (the user runs a pre-developed macro to append the new order data to "tbl_ order" and "tbl_orderline" tables). the existing order source tables "tbl_ebay", "tbl_E-junkie" and "tbl_amazon" must be remade in order to include all available API fields, even if they are not currently included in the tables. Please click link for related info: [login to view URL]
2. Make a macro called "macro_validate_shipping_address_with_USPS", that would update the "yes/no" data-type field "tbl_order.hold_invalid_adrrs" to "True", only if customer's ship-to address is identified as invalid by [login to view URL]'s address validation API. This is required because very often the customers don’t supply a correct shipping address and [login to view URL] rejects the shipment if the address is invalid.... Please click link for related info: [login to view URL]
3. Make an Access macro called "macro_export_to_order_source_data", that would run an API to export the shipping data from the Access table "tbl_order", to the online order sources Ebay, Amazon and e-junkie, only if the field "tbl_order.tracking_nmbr_ID" is not null and the field "tbl_order.time_stamp_exported_to _order_source" is null.
4. The user also uses Amazon also as a fulfillment (distribution) center to warehouse and ship some of his product and needs to run an API to inform him of the "Qty-on-hand" in the Amazon Fullfilment Center, in order to monitor the stock level... Make a macro called "macro_Updt_tbl_product_ID_AMZ_API_OHQ", that uses an API to populate the field "tbl_product.AMZ_API_OHQ" .
I am easy to work with and am hoping to find a reliable full time MS Access/VBA/Web developer for multiple projects.
please see the attached mockup sample database
I would like this project completed by July/22/13