Global set commission for all products in eStore

[dela]

We have 163 products set up in our eStore. We just purchased and installed WP Affiliate, and we want only one product right now to have an affiliate commission. Is there a way to globally set all products in the store to 0 commission? (then we’ll update the one product).

Thanks!

[wzp]

Use phpMyAdmin to edit the wp_eStore_tbl table, and set all values of the “commission” column to the desired value.

[dela]

I see commission in the Field column. Where do set the values? To the left, columns are Type, Collation, Attributes,

Null, Default, Extra (Action)

[wzp]

Use the following SQL commands:

UPDATE `wp_wp_eStore_tbl` SET `commission` = 0

This assumes you are using the default WP table prefix of: wp_

[dela]

Thanks. Do you happen to have a link to instructions for running the command? If not, I’ll ask the hosting service tech support for help.

[wzp]

It’s best to ask your hosting provider, because:

1. They may be running a different version than everyone else.

2. Your monthly hosting fee is supposed to include tech support.

[dela]

Great, thanks!

[Author]

Posts