search

kilbot / WooCommerce-POS

:bangbang: All development now at https://github.com/wcpos.
http://wcpos.com
GNU General Public License v3.0
353 stars 125 forks source link

Auto-assign POS sales to new store #125

Closed albertojm closed 8 years ago

albertojm commented 8 years ago

Hello,

I've using POS Free version, in my local store. After upgrading to PRO version, I've realized that all the data / sales generated by the free version are not being associated to any store, therefore I can't filter it in "Sales by Store".

Is there any way to move that data / sales to my "Custom Store"?

Regards.

kilbot commented 8 years ago

Hi Alberto, we'll have to run a custom query on your database to update past orders.

How is your experience with MySQL? Do you have access to a backend management tool like phpMyAdmin?

albertojm commented 8 years ago

Hey!

Pretty good, I do have full access to my MySQL data (via phpMyAdmin)

kilbot commented 8 years ago

OK, cool, Imma write some SQL for you to run .. it will be untested so please go into phpMyAdmin and download a backup just in case.

While you're there can you also get the table prefix (it's usually wp_, eg: wp_posts) and we'll also need the store ids (these will likely be the last entries in wp_posts).

kilbot commented 8 years ago

I should mention that you can change the orders one-by-one using the Edit Order screen, but I assume you have a large number of orders making that impractical?

screen shot 2016-05-24 at 1 44 48 pm

albertojm commented 8 years ago

Thank you for that!

My newly created phisycal store ID is 3117 (here's where the sales / data should be assigned) My other store ID it's 3120

And yes, I have a LOT of sales, so it would take me a lot of time to do that.

kilbot commented 8 years ago

Alright, let's do this in two stages to reduce the chance of mistake. Can you run the following in the SQL field: 

SELECT post_id FROM wp_postmeta
WHERE meta_key = '_pos' 
AND meta_value = 1

I'm not sure what phpMyAdmin will output ... hopefully it should be a list of IDs.

albertojm commented 8 years ago

Ok, the query result was:

Showing rows 0 - 29 (184 total, Query took 0.0015 sec)

kilbot commented 8 years ago

The next step would be to create an INSERT for each of those IDs, ie:

INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(****, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(****, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(****, '_pos_store', 3117);
...

In a good text editor like Sublime Text you should be able to convert the array of IDs into a list of INSERT statements.

If you can post the list of IDs I can create the list for you.

albertojm commented 8 years ago

I can do that, One question, wouldn't that duplicate the data? Or there's a following step to remove the old information that's not associated to an specific store?

kilbot commented 8 years ago

There is no old data, so this is new data going in. You just need to swap the **** above for each unique ID. It's a PITA but I can't think of an easier way at the moment, and it's slightly quicker in phpMyAdmin than writing a PHP function :)

albertojm commented 8 years ago

Done, query executed successfully.

But i'm still having an empty screen when clicking "Sales by store"

albertojm commented 8 years ago 
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(1748, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(1749, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(1750, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(1751, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(1752, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(1753, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(1754, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2555, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2557, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2558, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2559, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2561, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2562, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2563, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2564, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2565, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2566, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2567, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2568, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2569, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2570, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2571, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2587, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2588, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2589, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2591, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2592, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2594, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2595, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2596, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2597, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2598, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2599, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2600, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2604, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2608, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2609, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2610, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2611, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2613, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2614, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2649, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2650, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2651, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2652, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2654, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2655, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2657, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2668, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2669, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2670, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2677, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2678, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2679, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2682, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2689, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2695, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2702, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2704, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2705, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2706, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2707, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2708, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2709, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2710, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2715, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2716, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2718, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2724, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2727, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2728, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2729, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2732, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2733, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2734, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2736, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2738, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2741, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2742, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2743, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2744, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2745, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2746, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2747, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2748, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2749, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2750, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2751, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2779, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2786, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2787, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2788, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2789, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2790, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2794, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2795, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2796, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2797, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2798, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2799, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2803, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2804, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2807, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2811, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2812, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2813, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2814, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2816, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2817, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2805, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2818, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2820, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2821, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2822, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2824, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2830, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2832, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2833, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2834, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2835, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2836, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2837, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2838, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2839, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2840, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2842, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2843, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2844, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2845, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2846, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2847, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2849, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2850, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2851, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2852, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2853, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2859, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2860, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2861, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2862, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2927, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2928, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2929, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2930, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2931, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2932, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2933, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2935, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2974, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(2998, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3018, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3021, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3035, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3044, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3045, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3047, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3048, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3051, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3052, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3053, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3054, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3055, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3056, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3057, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3094, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3095, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3096, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3097, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3098, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3099, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3100, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3101, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3102, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3103, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3104, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3105, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3106, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3107, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3109, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3110, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3111, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3112, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3114, '_pos_store', 3117);
INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES(3115, '_pos_store', 3117);
kilbot commented 8 years ago

I believe the WooCommerce reports cache, so it could take some time before you get the updated results. Wait a day or two and then leave a comment if you're still not seeing the Store report.

albertojm commented 8 years ago

Awesome, thanks for the big help :)