How to interface to Ebay ecommerce system? (1 Viewer)

[amorosik]

How can I automatically communicate with an Access-based management system and e-commerce systems, such as eBay, from a seller's perspective?

By 'communicate,' I mean:
- create sales listings
- receive purchase order notifications
- manage tracking messages for shipped items

 

[CJ_London]

Depends on whether or not the site provides api’s to allow you to do what you actually want.

Each will be different, some are provided free, others you pay for a license

Review this link for eBay

eBay API - PublicAPI

eBay API provides Sell and Buy on eBay

publicapi.dev

Search sitename api for others
Search ‘rest api in vba’ for how to implement in access

As usual, your phrase ‘automatically communicate’ is vague. Automation will typically be from the access end to poll the site. So far as I am aware it is not possible for the site to automatically send reports, although you could get email
notifications of sales and other transaction events - use outlook automation or rules to process these

Edit - some sites regularly change the nature of what you download- content, name and location so be prepared to be fully involved with updating your processes to manage this - you should receive notifications from the site (or visit regularly) to keep abreast of any changes

 

[AngelSpeaks]

Well I believe you can export listings in csv format then import to Access.

 

[gemma-the-husky]

I've posted some stuff about interfacing access with a restive API. There isn't much information regarding using VBA.

 

[gemma-the-husky]

Basically the restive API exposes some methods. You call the message by sending a correctly formatted JSON string, and interpreting the JSON string that gets returned.

 

[amorosik]

Depends on whether or not the site provides api’s to allow you to do what you actually want.

Each will be different, some are provided free, others you pay for a license

Review this link for eBay

eBay API - PublicAPI

eBay API provides Sell and Buy on eBay

publicapi.dev

Search sitename api for others
Search ‘rest api in vba’ for how to implement in access

As usual, your phrase ‘automatically communicate’ is vague. Automation will typically be from the access end to poll the site. So far as I am aware it is not possible for the site to automatically send reports, although you could get email
notifications of sales and other transaction events - use outlook automation or rules to process these

Edit - some sites regularly change the nature of what you download- content, name and location so be prepared to be fully involved with updating your processes to manage this - you should receive notifications from the site (or visit regularly) to keep abreast of any changes

Yes, I emailed eBay staff for information, but no response
I signed up for the developer program on the eBay website, but there was no response either
It said the account would be activated within 24 hours, but after three days I still haven't heard back
I'll wait a few more days

 

[amorosik]

Well I believe you can export listings in csv format then import to Access.

Yes, but after exporting, how do you send the information to eBay systems?
And how do you receive completed purchase orders or any communications that may arrive?
The main goal is to manage everything from the company's management system and relegate the eBay web interface to emergency situations only.

 

[amorosik]

Basically the restive API exposes some methods. You call the message by sending a correctly formatted JSON string, and interpreting the JSON string that gets returned.

Yes, thank you
But the point isn't HOW to communicate, it's what commands can be sent/received and their correct syntax
Then i need the official documentation

 

[CJ_London]

How can I automatically communicate with an Access-based management system and e-commerce systems, such as eBay, from a seller's perspective?

But the point isn't HOW to communicate,

You’ll just have to try harder to join the developer program from a seller perspective. Do you have a seller account? I used Amazon and shopify a few years ago and had to have my client grant me access to their account to download the transaction history to consolidate into production orders.