sethbahookey

Okay! So it looks like I finally got it.

What I ended up doing was going through and manually finding the 32 orders that were dupes from the DB and created a query to delete from the wp_wc_order_stats, wp_woocommerce_order_items, wp_wc_order_product_lookup tables.

Then from there I went to the Setting page and set the date to 10-22-21 (a couple days before I started deleting dupes from the DB), and clicked start.

I’m now back on track with the correct sales data. Thank you!!

Can you help me understand why I need to ‘reimport’? I’m guessing WooCommerce just doesn’t look at the database each time to look at the data hence why it wouldn’t update when I deleted a record? Just curious why it’s setup like this for my own education in architecture/programming. ??

Thanks again,
Seth

Hi @mirko P.

Thanks for the updated query. It seems like I ended up with the same results. I know I did a big export/import awhile back when I had redesign the site so maybe that is why I’m getting all those extra orders.

I think I’ll just manually go through and pick out the orders to remove. Can you confirm if this is the only table required to update to remove the erroneous records from the Analytics>Orders page or is this page tied to other tables?

Thanks!
Seth

Thanks Mirko! When running that query I seem to get a lot more orders than just the duplicate ones. For example, the orders I’m having these duplicate issues with are from Oct. 25 – Nov. 2. and there are about 28 of them I can see, but when I run this query and append ‘and date_created > ‘2021-10-25’ I get close to 100 orders.

Further when I had isolated this down to one order originally it did not remove the record from the analytics>order page. The real order and then subsequent erroneous order was still showing in the list.

Is the wp_wc_order_stats table the one responsible for displaying the orders in the list or is there some other table that is hooked up to this?

Thanks again!

Hey just wanted to close the loop on this. I figured it out.

So for the styling issues on the WooCommerce homepage on the back end. This was due to Cloud flare. I’m assuming you guys had new CSS for how the styling was set up for this page and with Cloud flare it never seems to actually update until I purge the cache.

Once I did that it resolved it.

For the variations being jacked up and loading forever, it looks like it was the plugin SG Optimizer by Site Ground. Not surprised because they always seem to give me trouble.

Weird thing is I deactivated it, variations started working again. I activated it again, and variations kept on working. So maybe it just needed some kind of reset? Not really sure.

Either way I’m all good now, thanks again for the advice!

Seth

Thanks for the reply abwaita!
I’m not sure if it would be feasible for me to do this with my clients site right now as I’m using a child theme that I built and they would probably freak if I switch the theme on them lol. I might be able to try it in the wee hours of the night, but I guess I’m confused why it would be a plugin?

The reason I say this is because I did this first with a literal copy of my live site. I host through SiteGround and I made a stage of my production site, ran the WooCommerce updates and everything seemed fine. When I pushed the staging site back to live that is when things got wonky.

I could still try disabling plugins and seeing if that does the trick, but with the above comment does anything else come to mind?

Thanks for your insight!
Seth

Hi @3sonsdevelopment

Interesting, thanks for the quick response! I’m not a guru with SQL, but I’m definitely handy with it and would be totally fine with playing in the database (I have a proper workflow setup so I wouldn’t be cowboy coding). Do you know what the search is looking for in the database? If I could figure that piece out I could just single out the older orders and make an update statement. I’d like to try and do this with minimal plugins ??

Hi @3sonsdevelopment

Thank you for responding! No the search is just fine for any new orders that are coming through so just the old orders from the woocommerce plugin I purchased.

Do you know how the search on the backend works? Unfortunately I can never seem to find any legit dev docs that explain any functionality, and then when I think I find something it’s usually just someone trying to sell me a plugin that I have no interest in lol

I think I may have discovered something to pinpoint this a little better. I have one customer that had a purchase on the old site, and there are several purchases from them on the new site. When I type in that person’s name it only brings up the new orders, but the old order does not show; however, if I search by that user’s email address, then all orders show.

So I’m thinking it has something to do with the way the search works, the person’s name is all over the old order. Any ideas on why the old order isn’t showing up in the search when I go by there name?

Thanks!!

Nope, not resolved at all. Was waiting for someone to answer my question instead of an alternative solution. I have around 100-150 different attributes. All I need to know is how to setup the system to add a variation at the bottom of the page instead of the top. I suppose I’ll rewrite another post.

omg thank you so much!!!!! i can’t tell you how difficult it was to work with only 25 items. thanks!

Just made a discovery! I’m using the Genesis Framework and I think that is having some issues with your plugin. I switched over to GeneratePress and now they seem to be syncing up. Any ideas on that?

@kbassart

Thank you so much!! I actually had a copy of the older one and at one point it stopped working so I switched over to Relevanssi. I just disabled that and tried this new version and it works. It even works with variable SKUs!!

One question, when I search for a product through it’s variable SKU the site takes me to that product’s page, but it doesn’t have any of the attributes selected.

Is there a way to set it up so that the attributes of that searched SKU come pre populated to the page? Any advice would be greatly appreciated!!

Thanks again,
Seth

Sweet thanks! I got it to work ??

Thanks lorro! So do I have to move all of them for a change to take place? I tried copying in what you’ve posted to my functions page but when testing on my local machine, nothing was happening ??

Thank you so much for the response! When you mean ‘bits’ are you talking about 10 different add_actions on the content-single-product page?

Also, how would I actually move the functions around on this page. I see that each of them is commented out and looks like this

/**
/**
 * woocommerce_single_product_summary hook.
 *
 * @hooked woocommerce_template_single_title - 5
 * @hooked woocommerce_template_single_rating - 10
 * @hooked woocommerce_template_single_price - 10
 * @hooked woocommerce_template_single_excerpt - 20
 * @hooked woocommerce_template_single_add_to_cart - 30
 * @hooked woocommerce_template_single_meta - 40
 * @hooked woocommerce_template_single_sharing - 50
 * @hooked WC_Structured_Data::generate_product_data() - 60

Thanks again I really appreciate the help!

• This reply was modified 7 years, 4 months ago by sethbahookey.

Thanks for the reply! It doesn’t seem to be <br> tags just <p> tags. I have some icons in these boxes with <i> tags and for whatever reason it wants to place them in a <p> tag and then that messes up the styling.

Here is the site. https://thecompressioncloset.com/ If you scroll down about half way you will see it.

Thanks!