Currently there is not a way to lookup a product or price information by SKU or CODE. We would like to be able to use the price SKU to look up term and price information. We would like a way to see all price SKUs for a particular product.
We would like to know if a particular price SKU is used (referenced by) an offer.
Arc's private api has some search and capabilities but are not accessible using a developer token.
https://dmn.arcpublishing.com/retail/private/v1/product?sort=name&sortDirection=ASC&size=1000&search=active%3Dtrue
@jessica - Any updates on this?
Jessica - This will not work for all of our needs. We need to be able to get offer details by priceCode or SKU.
We are developing a cancelation workflow and need to compare current price code to a known list of other offers.
Thoughts on how to achieve this without having to sync a DB table on our side using your Private arc retail API mentioned in original request?
Richard - This should now be available as part of the data extract framework. https://redirector.arcpublishing.com/alc/arc-products/subscriptions/user-docs/arc-subscriptions-data-extraction-framework/
Please let me know if you need any more details.
This information will be available as part of the new extracts.
Thank you, Richard. This is great! We've got the information covered, and will follow-up with a timeline for when this work might fit.
Best,
-Michael
Yes, I believe the exact name is priceCode.
What you return for the current private pricing/strategy API endpoint would be great.
Example:
{"createdOn":1612454175000,"createdBy":null,"modifiedOn":1612454186000,"modifiedBy":null,"deletedOn":null,"id":1294,"amount":"17.29","billingCount":1,"billingFrequency":"Month","durationCount":1,"duration":"UntilCancelled","taxInclusive":false}],"publishedOffers":{"274":"DN FEB TRI DAY SALE Rev 2","275":"DN Valentine Sale 2021","295":"DN Ad Blocker Meter 02232021","296":"DN Coronavirus Meter 02232021","297":"DN Incognito Meter 02232021","298":"DN Interactives Meter 02232021","299":"DN Premium Content Meter 02232021"},"taxInclusive":false}
Like the example above, it should include rates array.
Like the example above, it should include published offers price is used on.
We have the price code via reports / checkout currently so that is what we would use as a reference.
Also, a way to get all published priceCodes (not just a specific one)
Sorry for the late reply.
Hi Richard! I'm new to the team, and had a few follow-up questions for you. Can you confirm I've got the details right?
It would be great to have a way to look up a product or price, by SKU or Code
The results of that call should return term and price information about the SKU or Code
It would be great to see all prices for a particular SKU
Additionally, you would like a way to know if a SKU is used by an offer
One question about this -- do you want to search by price and SKU, or just SKU?
Thank you for submitting the idea to us!
Best,
-Michael