EasyPopulate 4.0 Support Thread

[mc12345678]

Yes, it was consecutive entries on the spreadsheet (nothing to do with product_id).

I already ran it with both 001, and 002, didn't see anything unusual the only odd thing that on products all display if i sorted by model number for example 001-101, then 001-1001, 001-1019, 001-102, 001-1020... that kind of sorting, but it will do the same in both scenarios.

I will use 002 just to be safe.

So, if all of the entries had 4 digits after the - and these now only have three, you could use 002-0 as the prefix and that would put them in a somehat numerical order. You could also get real picky about it, and if want all items to have 4 digits after the dash, could imploy the query with an additional catch on the where part:

So here the concat would have '002-000'
Where products_model = '' and products_id < 10;
And then have 002-00
Where products_model = '' and products_id < 100;
And then have 002-0
Where products_model = '' and products_id < 1000;
And then have 002-
Where products_model = '' and products_id < 10000;
(Thankfully no product has products_id = 0 otherwise would need one more. But thatthe "lazy" way to apply the formatting.