zhuzh1

@serafinnyc,

Thanks for your advice

JZ

@fernashes thanks for your response which helped me in searching the answer.

I have updated the other related question to document an answer. It contains an sql query for others to use: https://www.ads-software.com/support/topic/productcategory-correlations-in-wp-woo-database/#post-11522442

@serafinnyc, @fernashes

Thanks for your insights and responses which helped a lot.

Eventually, I used the following query to retrieve corresponding vendor_id and category_id by the post_id for the product (for those who have not dived deep in Woo: products are stored in wp_posts table where post_type=’product’):

select t.term_taxonomy_id, t.taxonomy
from wp_term_taxonomy as t, wp_term_relationships as r
where
r.term_taxonomy_id=t.term_taxonomy_id and
t.taxonomy in (‘product_cat’, ‘wcpv_product_vendors’) and
r.object_id=1051;

in the query, 1051 is post_id/product_id. The result is, hopefully, self-explanatory:

term_taxonomy taxonomy
————- ——–
23 wcpv_product_vendors
44 product_cat

• This reply was modified 5 years, 6 months ago by zhuzh1.

I have been using distance-rate-shipping plugin for similar purpose. It is backed by woocommerce.

Good luck

John

Just a thought, can you make the numbers part of description (so the
buyer can read) but leave numbers in corresponding price column as 0?

John

A half-baked solution, in a nutshell:
1. one Product category per vendor;
2. one page per vendor which lists only products under the category
3. When a customer enters a page, check if the cart has another vendor’s product, if does, remind the customer as such. Otherwise, clear the cart before enter the page.

if you like, email me so I can explain

Hi @ryanr14

Thanks for the information. I’ll review the list.

I am wondering if this (lack of woo configuration file) has anything to do with the fact any functional woocommerce site is very much dependent on a list of plugins which means a functional site will not dependent on woo’s configuration but also configurations of other plugins.

Just curious

Hi @fernashes,

Thanks for the pointer. It helps a lot.

hey, @jobthomas,

I meant to give customers (after their login) a button “my purchases” which will give a list of purchases made by the customer.

I think this is how to read it:

a:2 means an array of 2 elements
s:5 means a string of 5-char
i:1 means an integer of 1-digit

so on and so forth

I ended up modifying the code in order-email-to-vendors.php. I did

1. retrieve vendor timezone from $vendor_data[timezone] as the app is a multi-vendor marketplace
2. convert the $order_date to the timezone:
$order_date->setTimeZone(new DateTimeZone(timezone),
then
3. use $order_date->format(…) to add the date (including the hour and minute) into the email.

I don’t if your situation is the same as mine.

I run a clear-cart script to clear existing cart when a customer enters the site from outside (from google search, from referral sites etc).

https://stackoverflow.com/questions/20954448/how-to-clear-a-woocommerce-cart

Good luck

Just speculate: should you list all zipcodes for each city as well?

Good luck, please keep me updated how does this work out for you

JohnZ

Vendor data is in termmeta table with key_value=’vendor data’

@wpriders

Just an update:

I moved email-order-details.php for Product Vendors plugin to a child theme’s directory
~/wp-content/storefront-child/woocommerce-product-vendors/templates/emails/ then made changes. In my test, woocommerce still picked up the one (email-order-details.php) in the original plugin directory, not the one in my child theme.

My thinking: without child theme, plugin files are all outside of the theme (I am storefront now). To move them inside my child theme, Should I follow some convention to structure directories for them to be picked up?

Thanks

John