I am using Zapier to import woocommerce orders into BigQuery and build a datawarehouse with paid orders from multiple sites. However, multiple sites generate an ID per site, not a unique id globally for all, so importing into the same table data from all the woocommerce orders will not have unique ids.

I would like BigQuery to automatically assign a unique id to every new order that enters the table. Is this possible?

  • Cant you use the tuple site_id, order_id as a key? Aug 22, 2022 at 21:44
  • Thanks for your comment, there is not site_id in the woocommerce database, and the order_id is only unique to 1 website not all of them. Aug 23, 2022 at 10:44
  • You have nothing that identifies a site? Aug 23, 2022 at 20:28


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy