The products ARE in woocommerce. All of them. Wp-lister syncs the stock levels IN woocommerce based on amazon orders. The whole thing works smoothly.
I am only trying to establish a link between ATUM and WP-Lister, which can listen to Amazon sales data as fetched by wp-lister.
How is SOLD TODAY and Sold in the last 14 days data calculated? Does it run queries on orders or does it store it on an incremental basis?
Let me explain exactly what happens:
Product is in Woo > Sale happens on Amazon > Wp-lister fetches the order (in its own table of Amazon Orders. I currently do not import it in woocommerce.) > Inventory is programmatically reduced.
I want to record this inventory reduction/addition as a sale in ATUM.