Hello sorry for the late response. Happy Holidays!
My populate query is:
const populateQuery = [
{
path: "department",
model: Department,
},
{
path: "category",
model: Category,
},
{
path: "variations",
model: Variation,
populate: [
{
path: "color",
model: Color,
},
{
path: "size",
model: Size,
},
{
path: "stock",
model: Stock,
populate: [
{
path: "materials.material",
model: Material,
},
{
path: "labourCost",
model: LabourCost,
},
],
},
{
path: "images",
model: ProductImages,
populate: [
{
path: "images",
model: "Image",
},
],
},
],
},
];
Product.findOne({}) is:
{
"_id":"63a5bcc57433d072405cde86",
"name":"Ali's Boxers",
"description":"Boxers made specifically for ALi",
"department":"6398fbf11fc0f2835e898aa8",
"category":"6398fbfd1fc0f2835e898aae",
"variations":[
"63a5bcc57433d072405cde8d",
"63a5bcc67433d072405cde95"
],
"price":50,
"discount":0,
"identifier":"A",
"createdAt":"2022-12-23T14:35:50.556Z",
"updatedAt":"2022-12-23T14:35:50.556Z",
"__v":0
}
Product.findOne({}).populate(populateQuery) is:
{
"_id":"63a5bcc57433d072405cde86",
"name":"Ali's Boxers",
"description":"Boxers made specifically for ALi",
"department":{
"_id":"6398fbf11fc0f2835e898aa8",
"name":"male",
"description":"male",
"skuCode":"M",
"createdAt":"2022-12-13T22:25:53.549Z",
"updatedAt":"2022-12-13T22:25:53.549Z",
"__v":0
},
"category":{
"_id":"6398fbfd1fc0f2835e898aae",
"name":"main",
"title":"main",
"description":"main",
"skuCode":"M",
"parent":null,
"createdAt":"2022-12-13T22:26:05.996Z",
"updatedAt":"2022-12-13T22:26:05.996Z",
"__v":0
},
"variations":[
{
"_id":"63a5bcc57433d072405cde8d",
"color":{
"_id":"6398fbdb1fc0f2835e898a91",
"name":"red",
"code":"#d44a4a",
"skuCode":"001",
"createdAt":"2022-12-13T22:25:31.140Z",
"updatedAt":"2022-12-14T08:26:36.023Z",
"__v":0
},
"size":{
"_id":"6398fbe61fc0f2835e898aa1",
"name":"small",
"skuCode":"Y",
"createdAt":"2022-12-13T22:25:42.795Z",
"updatedAt":"2022-12-13T22:25:42.795Z",
"__v":0
},
"stock":[
{
"_id":"63a5bcc57433d072405cde89",
"available":2,
"reserved":0,
"store":0,
"labourCost":{
"_id":"63a1deb1d5890e2103410bf4",
"title":"Ali Boxers Maker",
"description":"Ali needs his boxers hand made",
"amount":20,
"createdAt":"2022-12-20T16:11:29.690Z",
"updatedAt":"2022-12-22T17:06:37.667Z",
"__v":0
},
"materials":[
{
"amount":1,
"material":null,
"_id":"63a5bcc57433d072405cde8a"
},
{
"amount":1,
"material":{
"_id":"639a251596ae4b5c1af788c0",
"name":"mamam",
"description":"2121",
"stock":121195,
"supplier":"test",
"costPerUnit":1,
"fabric":"polyester",
"createdAt":"2022-12-14T19:33:41.047Z",
"updatedAt":"2022-12-25T01:40:56.383Z",
"__v":0
},
"_id":"63a5bcc57433d072405cde8b"
}
],
"createdAt":"2022-12-23T14:35:49.735Z",
"updatedAt":"2022-12-23T14:58:06.156Z",
"__v":0
}
],
"images":{
"_id":"63a5bcc57433d072405cde87",
"product":"63a5bcc57433d072405cde86",
"color":"6398fbdb1fc0f2835e898a91",
"images":[
{
"_id":"6375c3d97d5dc191a77ca7ac",
"name":"boutiqueb-hahhaha-1668662233138.jpeg",
"displayName":"hahhaha",
"createdAt":"2022-11-17T05:17:13.159Z",
"updatedAt":"2022-11-17T05:17:13.159Z",
"__v":0
},
{
"_id":"6375c40d7d5dc191a77ca7c2",
"name":"boutiqueb-paypal-1668662285552.jpeg",
"displayName":"paypal",
"createdAt":"2022-11-17T05:18:05.570Z",
"updatedAt":"2022-11-17T05:18:05.570Z",
"__v":0
}
],
"createdAt":"2022-12-23T14:35:49.561Z",
"updatedAt":"2022-12-23T14:35:49.561Z",
"__v":0
},
"createdAt":"2022-12-23T14:35:49.897Z",
"updatedAt":"2022-12-23T14:35:49.897Z",
"__v":0
},
{
"_id":"63a5bcc67433d072405cde95",
"color":{
"_id":"639b75a799cf2ed9eb2802ec",
"name":"dr",
"code":"#301313",
"skuCode":"002",
"createdAt":"2022-12-15T19:29:43.798Z",
"updatedAt":"2022-12-15T19:29:43.798Z",
"__v":0
},
"size":{
"_id":"639b759899cf2ed9eb2802e4",
"name":"medium",
"skuCode":"Z",
"createdAt":"2022-12-15T19:29:28.047Z",
"updatedAt":"2022-12-15T19:29:28.047Z",
"__v":0
},
"stock":[
{
"_id":"63a5bcc67433d072405cde91",
"available":2,
"reserved":0,
"store":0,
"labourCost":{
"_id":"63a1deb1d5890e2103410bf4",
"title":"Ali Boxers Maker",
"description":"Ali needs his boxers hand made",
"amount":20,
"createdAt":"2022-12-20T16:11:29.690Z",
"updatedAt":"2022-12-22T17:06:37.667Z",
"__v":0
},
"materials":[
{
"amount":1,
"material":null,
"_id":"63a5bcc67433d072405cde92"
},
{
"amount":1,
"material":{
"_id":"639a44fc5a053c1a05e60b44",
"name":"test emile",
"description":"test test",
"stock":2,
"supplier":"emile",
"costPerUnit":1,
"fabric":"cotton",
"createdAt":"2022-12-14T21:49:48.322Z",
"updatedAt":"2022-12-25T15:46:03.105Z",
"__v":0,
"image":"63a8703adb0f557f329cabfa"
},
"_id":"63a5bcc67433d072405cde93"
}
],
"createdAt":"2022-12-23T14:35:50.229Z",
"updatedAt":"2022-12-23T14:35:50.229Z",
"__v":0
}
],
"images":{
"_id":"63a5bcc67433d072405cde8f",
"product":"63a5bcc57433d072405cde86",
"color":"639b75a799cf2ed9eb2802ec",
"images":[
{
"_id":"6375c3d97d5dc191a77ca7ac",
"name":"boutiqueb-hahhaha-1668662233138.jpeg",
"displayName":"hahhaha",
"createdAt":"2022-11-17T05:17:13.159Z",
"updatedAt":"2022-11-17T05:17:13.159Z",
"__v":0
},
{
"_id":"6375c40d7d5dc191a77ca7c2",
"name":"boutiqueb-paypal-1668662285552.jpeg",
"displayName":"paypal",
"createdAt":"2022-11-17T05:18:05.570Z",
"updatedAt":"2022-11-17T05:18:05.570Z",
"__v":0
}
],
"createdAt":"2022-12-23T14:35:50.067Z",
"updatedAt":"2022-12-23T14:35:50.067Z",
"__v":0
},
"createdAt":"2022-12-23T14:35:50.395Z",
"updatedAt":"2022-12-23T14:35:50.395Z",
"__v":0
}
],
"price":50,
"discount":0,
"identifier":"A",
"createdAt":"2022-12-23T14:35:50.556Z",
"updatedAt":"2022-12-23T14:35:50.556Z",
"__v":0
}