jaewp
Forum Replies Created
-
Lol, not sleeping yet.
Thanks Tanjir Al Mamun for the thought.
I didn’t change mapping but switched a couple of the general initial settings, that seemed reasonable at the time, and it looks like I’m getting a whole feed first try.
Now let’s see what Google says!
Thanks everyone for reading and obviously Josh and Tanjir for walking with me.
Let me know if anyone reading needs elaboration but basically just copy the first screen of any default feed you create without change.
ZZZZzzzzzzzI will give that a try..maybe tomorrow though 😃, one of those long days (you know I’m sure).
Thanks for jumping in,! as I mentioned my agreement is to keep things pretty tight and that includes the site and even the categories so mostly I’ve provided what I’m able to. See previous post noting the multiple manual refreshes I performed. Sorry my hands are a bit tied but I have to believe the level of detail lost is not really applicable to the issue.
Thanks for sticking with me, I’m used to issue but with a feed this is a first time!
No rules or filtersSingle products – 5737, variation products 126, total products 5863
WordPress 6.72, Woo 9.62, PFP 13.4.1.3
PHP 8.2.26
I think that caught it all. I really just updated everything prior to this.- This reply was modified 1 year, 3 months ago by jaewp.
My hands are a bit tied. I could SNIP the url and site identifier but even the product categories should probably be removed per my agreement. Are there sections that might be useful that are not directly related? Sorry it’s so difficult to help in this instance.
You can certainly see my attempts but I’ve elaborated on those:[history_products] => Array ( [22] => Array ( [19 Feb 2025 00:41:45] => 746 ) [23] => Array ( [19 Feb 2025 00:52:00] => 1992 ) [24] => Array ( [19 Feb 2025 00:54:34] => 1992 ) [25] => Array ( [19 Feb 2025 00:58:05] => 1992 ) [26] => Array ( [19 Feb 2025 01:03:02] => 746 ) [27] => Array ( [19 Feb 2025 01:04:01] => 746 ) [28] => Array ( [19 Feb 2025 01:05:47] => 746 ) [29] => Array ( [19 Feb 2025 01:16:59] => 1992 ) [30] => Array ( [19 Feb 2025 01:18:28] => 1992 ) [31] => Array ( [19 Feb 2025 01:18:28] => 1992 )Thanks but I simply can’t get it to list all the products.
We’re not dealing with changes per. se., just trying to produce the initial feed and the most I can get is around 2,000. In fact the number often drops on refresh. It’s bizarre.
Appreciate the super quick help.
P.S. the most I’ve been able to do (multiple times) is actually 1992 despite the settings for 1999.- This reply was modified 1 year, 3 months ago by jaewp.
Forum: Plugins
In reply to: [WooCommerce] Change next WooCommerce Product ID in SQLOk, I’ve solved this and here are some notes for others.
First, to check what your next increment is without adding a new product in the back officeSELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA = "yourDatabaseName" AND TABLE_NAME = "yourTableName"Then to change that increment
alter table yourTableName auto_increment=startingNumber;Your mileage may vary, be careful.
Forum: Plugins
In reply to: [WooCommerce] Change next WooCommerce Product ID in SQLThanks again. I can’t seem to locate those tables, they don’t show in my list (and, yes, I removed the prefix initially).
When I run the query (after removing “wp” of course) I get an error:
1146 – Table ‘MYDATABASE.posts’ doesn’t exist
Strange. Hoping someone comes along and helps out but depending on how its set the limit of numbers is not going to be an issue and, rather, it’s about consistency of the shop.
I still wonder why the import allowed me to change the next increment? I could not replicate that with another import.
I can still force an ID on import (like it must have happened initially) but then adding new products the next increment goes back to the original number I mistakenly set rather than the next number for the newly set ID.
Thanks for taking the time to make the comments, I realize it is out of scope of your normal help but figured this was the best place to ask.- This reply was modified 2 years, 3 months ago by jaewp.
Forum: Plugins
In reply to: [WooCommerce] Change next WooCommerce Product ID in SQLThanks, I’ll check the community and have done a fair amount of research prior to coming here but always old information.
Really?, Historically I thought this only effected 2 tables and was fairly straightforward, I simply don’t know where this increment is stored.An old reference that indicated tables that don’t seem to exist anymore (though it referenced Woocommerce) noted the statement as:
ALTER TABLE wp_posts AUTO_INCREMENT = 10000; ALTER TABLE wp_post_meta AUTO_INCREMENT = 10000;Forum: Developing with WordPress
In reply to: Taxonomy in backend automatically to menu and in order?Thanks.
My categories were imported from another platform and I just fixed relationships.
In terms of a woocommerce setup it feels clunky and the category taxonomy does not hold under appearance-menus-product categories. I realize that WordPress itself is not an ecommerce platform.
I just ended up rebuilding the menus a line at a time using search.
Again, since I already set up the category taxonomy it would have been nice to just click something that added the full category list with accurate taxonomy.
For me I’m done anyway but spent a good deal of time searching for what I thought would be a basic plugin so maybe the posting will help someone down the road.
Thanks for the detailed reply.