Hey @hatunoglu,
Thank you for reaching out! I’m afraid that SliceWP was not built to suit the particular setup you have.
I’m afraid that currently, you cannot mark a visits as converted from the administrator interface, as this is handled automatically via the integrations we support.
The only option available at the moment would be for you to add the commission’s unique ID in the “slicewp_visits” database table, to the corresponding visit, via your hosting provider’s interface.
I know this solution is far from the best, but it’s one that works.
I have added your thoughts to our development log for future research. Even so, from what I see, you’re the first to ask about this, so I’m not sure if and when this particular feature will be added to the plugin.
I’m really sorry I could not help you with more on this one!
Thank you and best wishes,
Mihai
Hello,
I have now been asked to develop the feature I mentioned. So I started writing a plugin suitable for this. However, I did not fully understand which values I should enter in which fields in the database. You wrote that I should enter entries in the “slicewp_visits” table, but doesn’t the “slicewp_commissions” table also concern this field?
Can you share exactly all the changes that will occur in the db if a visit turns into a full purchase? In this way, I can offer this editing opportunity to the user in the data table I will write myself.
Hey @hatunoglu,
Technically, the way the system works when you have an eCommerce integration active is that when a referred order comes in, a commission is generated for the referring affiliate.
This commission is added to the “slicewp_commissions” table and will have a unique ID.
Then, to mark the visit as converted, we attach this new commission’s unique ID to the visit in the “slicewp_visits” table.
If you explore the “slicewp_visits” table, you’ll notice there’s a column named “commission_id”. If you place the commission’s unique ID in this column for an existing visit, the visit will be considered converted.
Thank you and best wishes,
Mihai
