How to iterate over entire table? | Medusa Community | Page 1

keen trellis Jan 7, 2023, 5:39 AM

#

I am trying to iterate over the entire product table, in order to create variants for it, like this:

  let productList = await productService.listAndCount(
    {},
    { skip: skip, take: 20 }
  );

Where skip is an incrementing (+20 each iteration) value. My impression is that this would go through the entire products table, grab 20 rows, process them, etc, etc.

However I seem to be getting duplicates sometimes of products that I already have grabbed... is there a reason for this? Is there a way to avoid this?

hardy sedge Jan 7, 2023, 7:29 AM

#

You are taking 20 prod randomly. You need to add an order

#

For example ordering by created at

keen trellis Jan 7, 2023, 4:41 PM

#

hardy sedge For example ordering by created at

Oh got it, thanks. I figured that Medusa was doing it descending automatically, I'll add explicit ordering, thanks

#How to iterate over entire table?