Find Jobs
Hire Freelancers

API to integrate USPS, Ebay and Amazon with MS Access - repost 2

$250-750 USD

已关闭
已发布超过 10 年前

$250-750 USD

货到付款
Specs: The user is an online merchant, selling with ebay, Amazon. 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 developer to modify the attached mockup database and populate the API Access macros (which are currently empty because they are mockups). the Access macro code can be made using a language such as ".net" and the API tables do not have to be Access, MYSQL, SQL Server... is also OK. 1. the 2 macros called: • "macro_API_import_from_order_source_data_amazon", • "macro_API_import_from_order_source_data_ebay" would run an API to import new customer-order data from the order sources Ebay and Amazon . The order data would be appended to the tables, "tbl_ebay", and "tbl_amazon" (the user already runs a pre-developed macro to append the new order data to "tbl_ order" and "tbl_orderline" tables, so making such a macro to append to the order and order line tables is NOT in your specs). the existing order source tables "tbl_ebay", and "tbl_amazon" must be modified in order to include all available API fields that are provded by the order source API, even if they are not currently included in the mockup tables. [login to view URL] a macro called "API_macro_validate_shipping_address_with_USPS", that would update the "yes/no" data-type field "tbl_order.hold_invalid_adrs" to "True", only if ship-to address fields in "tbl_order" are 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. the 2 macros called:: • "macro_API_export_to_order_source_data_amazon "macro_API_export_to_order_source_data_ebay " would run an API to export the shipping data from the Access table "tbl_order" and export to the online order sources Ebay and Amazon, 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 sometimes uses Amazon's "Fulfilled By Amazon" ("FBA" service) as a distribution center to warehouse and ship some of his product ( FYI [login to view URL]) and needs to run an API to inform him of FBA related data e.g. "Quantity-on-hand" in the Amazon Fulfillment Center, in order to monitor the stock level... Make a macro called " macro_API_fulfilled_by_amazon", that uses an API to populate the table " tbl_fulfilled_by_amazon" with all of the available fields offered in Amazon's FBA API . I am easy to work with and am hoping to find a reliable full time MS Access/VBA/Web developer for multiple projects.
项目 ID: 4846806

关于此项目

5提案
远程项目
活跃11 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
5威客以平均价$426 USD来参与此工作竞价
用户头像
Responsive PHP/Amazon/MS Access expert is here. Let's discuss.
$473 USD 在3天之内
4.9 (7条评论)
4.3
4.3
用户头像
am able hire me
$555 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi, I am ready to do your job as well. Thanks!
$600 USD 在7天之内
0.0 (0条评论)
0.0
0.0
用户头像
No upfront payment is required. Milestone number is only because of freelancer requirement. Hi, I have over 8yrs of experience working with Macors for Microsoft products (word, excel, access). I understand you requirements and would like to take up this project. Additional details are in the private message. I look forward to working with you thanks & regards
$250 USD 在20天之内
0.0 (0条评论)
0.0
0.0
用户头像
I am ready for this project. Thank you.
$250 USD 在4天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
bronx, United States
5.0
1
付款方式已验证
会员自5月 2, 2012起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。