Suspend Site and Pause Marketplace Integration
Review Suspend Site and Pause Marketplace Integration
Glossary
Site suspended means: inProduction = false, requiresEngineering = true, suspendBilling = true.
See on this page:
https://m1.omnivore.com.au/retailer/all-that-digi/summary
Site parked means: the product import cron expression has a special value of
13 14 15 ? * SAT
A site is parked after 7 days of connection errors. Parking also affects the frequency of order jobs.
Site paused means: inProduction = true, requiresEngineering = true, ie no jobs are executed for the site, but jobs might still be created for the site.
For the purpose of this FAQ, active billing means: there's been at least one invoice paid in the last 60 days. It goes by the "paid date" not the "created/raised date", ie if they're catching up on old unpaid invoices it's ok.
See info at the bottom of this page:
https://m1.omnivore.com.au/retailer/all-that-digi/invoices
Note: paid invoices of zero amount are ignored for the purpose of active billing calculation.
Marketplace integration paused means: the integration status current value is PAUSED when you look at the marketplace general config page, eg:
https://m1.omnivore.com.au/configuration/ebayMarketplace/all-that-digi?marketplaceCode=ebay
Connection issues to the retailer backend and to the marketplace are detected twice a day in the job STATUS_CHECK.
The job is not supposed to fail even if the connection is broken. Look for the content of the job message.
A site is suspended if:
- At least 30 days since the connection was broken.
- No active billing.
Before we suspend a site we send the email RETAILER_CONNECTION_ISSUE.
When the site is suspended we send RETAILER_SUSPENDED.
We also send RETAILER_BILLING_ISSUE but this doesn't result in an automatic suspension currently.
A marketplace integration is paused if:
If this is not the only active marketplace integration:
- At least 10 days since the connection was broken
If this is the only active marketplace integration:
- At least 10 days since the connection was broken.
- No active billing
Before pausing a marketplace integration we send the email named MARKETPLACE_CONNECTION_ISSUE.
When we pause the marketplace integration we send the email MARKETPLACE_PAUSED.
Questions and Answers
Not all these currently have an easy answer.
What site connections went bad in the last N days?
https://m1.omnivore.com.au/admin/query?queryName=Connection+issues%3A+retailers&renderAs=Render+as+HTML&days=7&_action_query=Run+Query
What active site have connection errors?
Same query as above with a big number in the days field:
What sites were paused in the last N days?
Can't be answered with a query.
What sites might be paused in the next N days?
Billing status is hard to do with a query. Use the query above, look at the num_days column and know that we suspend after 30 days if no active billing.
What marketplace connections went bad in the last N days?
What marketplace integrations were paused in the last N days?
https://m1.omnivore.com.au/admin/query?queryName=Marketplace+integrations%3A+changes+since+num+days&renderAs=Render+as+HTML&days=7&integration_status=PAUSED&_action_query=Run+Query
No value in the column integration_status_changed_by means this was an automated action of the system.
You should find a corresponding entry in the event log, eg:
Tables can't be imported directly. Please insert an image of your table which can be found here.
Tables can't be imported directly. Please insert an image of your table which can be found here.
What marketplace integrations might be paused in the next N days?
billing status is hard to do with a query.
For a given site, can I see all these changes in the Omnivore GUI?
Yes. The change log for site should capture all. Some actions are also creating a Note.
All queries related to connection errors
- Sites: parked sites
- Connection issues: retailers
- Connection issues: all marketplaces, all active sites
- Connection issues: all marketplaces, errors since
- Marketplace integrations: changes since num days
- Marketplace integrations: changes where connection errors
Related Trello: https://trello.com/c/ncGMhLiI/1623-automated-suspension-pause-of-marketplaces-and-accounts
~