Shortcode doesn’t show products

Hi @ihereira,

Kindly please reply, It’s that true ? woo-commerce short code: [products ids=”]
will accept only 3161 ids ? because i load 3808 ids into that, it not work when i remove 647 ids from that then works.! Please advise.

Hello @rainfallnixfig,

Thanks for your replay, your information really useful for me. I noted that.

In my case what i understand i think i reach string limit, i am not sure please advise if i am wrong.

When i copied all product ids from database paste into products ids param like this:

[products ids= “5636,5637,5638,5639,5640,5641,5642,5643,5644,5645,5646,5647,5648,5649,5650,5651,5652,5653,5654,5655,5656,5657,5658,5659” columns=”3″ limit=”12″ pagination=”yes”]

i copied all ids into MS word and checked the character count i noticed its 19000 characters total.
This same code work if i remove some ids (when characters around 15000)

Hello @maykato,

Thanks for your replay. I can’t create category because i load products based on countries.

My current category for ex:

– Grocery
– Food
– Electronics
– Mobiles
– Home Appliances
– Offers`

If i create country based category it will be like this. and it’s hard to manage.

– USA
– Grocery
– Food
– Electronics
– Mobiles
– Home Appliances
– Offers`
– UK
– Grocery
– Food
– Electronics
– Mobiles
– Home Appliances
– Offers`

Is there any alternative option can suggest ? because currently we have 4000 products if we expand to another country it will double or more

• This reply was modified 4 years, 2 months ago by Haja.

Hello @margaretwporg,

We have page:
– Shop page
– category1 page (Ex: Grocery)
– category2 page (Ex: Electronics)
– category3 page (Ex: Mobiles)

We have product:

products from USA:
usa_prd_1, usa_prd_2, usa_prd_3 … usa_prd_2000

products from UK:
uk_prd_1, uk_prd_2, uk_prd_3 … uk_prd_2000

Shop currenctly displayed all USA & UK products, thats why we go with shortcode

[products ids=’$ids_list’ columns=’3′ limit=’12’ pagination=’true’]

In $ids_list we store only ids based on geo location using SQL Query.

category will not work for us. because we don’t have country based category. its hard to maintain.

I’ve noticed:

When we pass WC_Shortcodes::products it will convert code pass into WP_Query like this ($ids area list of ids will add)

$query = new WP_Query( array (
				"post_type" => "product",
				"post_status" => "publish",
				"ignore_sticky_posts" => true,
				"no_found_rows" => 0,
				"orderby" => "price",
				"order" => "ASC",
				"posts_per_page" => 12,
				"meta_query" => [],
				"tax_query" => array(
						array( 
						"taxonomy" => "product_visibility",
						"field" => "term_taxonomy_id",
						"terms" => [7,9],
						"operator" => "NOT IN"
						),
					),
				"post__in" => $ids,
				"paged" => 0,
				"prdctfltr_active" => true,
				"fields" => "ids"
			) );

$query->posts will have first 12 product ids which is need to display.
Ex:

"posts": [
        342,
        439,
        431,
        453,
    ]

but when its contain more ids $query->posts return empty
Ex:
"posts": []

I need some tech ppl advise to fix this