Hello,
I have succesfully uploaded about 5000 products which i got from an API callā¦
I have used a runner because otherwise i get an error 500 because of the overloadā¦
I used this as test script in my Getproducts callā¦
var jsonData = pm.response.json();
pm.environment.set("productData", JSON.stringify(jsonData));
In my Post call to add the products in batches to woocommerce i used this pre-request-script:
var productData = pm.environment.get("productData");
if (productData) {
var products = JSON.parse(productData);
var batchSize = 100; // Batchgrootte instellen
var startIndex = pm.environment.get("startIndex") || 0; // Haal de startindex op uit de omgevingsvariabele of gebruik 0
var batchProducts = products.slice(startIndex, startIndex + batchSize);
var createdProducts = [];
for (var i = 0; i < batchProducts.length; i++) {
var product = batchProducts[i];
if (product.statusgroup === "New") {
var postBody = {
"name": product.title,
"description": product.longdescription,
"short_description": product.description,
"sku": product.itemcode,
"regular_price": product.suggestprice.toString(),
"manage_stock": true,
"stock_quantity": product.stockfree + product.externalstock,
"backorders": (product.backorder === 1) ? "notify" : "no",
"categories": [
{
"name": product.categoryname2
}
],
"images": [
{
"src": product.productimage
}
]
};
createdProducts.push(postBody);
}
}
if (createdProducts.length > 0) {
// Pas de aanroep aan voor batchverwerking
pm.request.url = 'https://xxxxxxxxx/wp-json/wc/v3/products/batch';
pm.request.method = 'POST';
pm.request.header = {
'Content-Type': 'application/json',
'Authorization': 'Bearer xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'
};
pm.request.body.raw = JSON.stringify({ "create": createdProducts });
// Update de startindex voor de volgende batch
var nextIndex = startIndex + batchSize;
pm.environment.set("startIndex", nextIndex);
} else {
console.log("Geen nieuwe producten om toe te voegen.");
}
} else {
console.error("productData is niet beschikbaar in de omgevingsvariabele.");
}
Apart from the categories, the sku, prices and stock all is being added nicelyā¦ If someone could tell me how to fix the categories i would be gratefullā¦ I tried to use toString() and parseInt() but it made no differenceā¦
The next problem i am facing is I am using a seperate call āGetproductimagesā which gives me back a JSON like this:
[
{
"mediaparentid": 8509838,
"itemcode": "0318C001",
"versions": [
{
"mediaid": 8510448,
"url": "https://productimages.nl/media/image/high/9bfc9ab88f9e32357af0ab85b21bc0c71c19dec9d782b60c3d4c5701222108ae.jpg",
"quality": "high",
"filetype": "jpg",
"filesize": 62347,
"width": 1000,
"height": 1000,
"checksum": "9bfc9ab88f9e32357af0ab85b21bc0c71c19dec9d782b60c3d4c5701222108ae"
},
{
"mediaid": 8510446,
"url": "https://productimages.nl/media/image/low/a9318850c82328085aa3cad96b7e5c6f4acfc4fcf7c9a704269130838cddb060.jpg",
"quality": "low",
"filetype": "jpg",
"filesize": 4606,
"width": 200,
"height": 200,
"checksum": "a9318850c82328085aa3cad96b7e5c6f4acfc4fcf7c9a704269130838cddb060"
},
{
"mediaid": 8510447,
"url": "https://productimages.nl/media/image/medium/e8ef719f4a232a5463fce0d9b61ad395ec9ac57a7a995d49739e1ccb015e5846.jpg",
"quality": "medium",
"filetype": "jpg",
"filesize": 18764,
"width": 500,
"height": 500,
"checksum": "e8ef719f4a232a5463fce0d9b61ad395ec9ac57a7a995d49739e1ccb015e5846"
},
{
"mediaid": 8510445,
"url": "https://productimages.nl/media/image/thumb/b8aeee6abb32bafe38979d7901897025ce5b5366711c062daeea912a4e023895.jpg",
"quality": "thumb",
"filetype": "jpg",
"filesize": 1304,
"width": 75,
"height": 75,
"checksum": "b8aeee6abb32bafe38979d7901897025ce5b5366711c062daeea912a4e023895"
}
]
},
I want to add the pictures which has the quality: āhighā to be added to the productsā¦ The products are allready created, the itemcode from the productimages could be used to correspond with the SKU in woocommerceā¦ Would it be better to do this before i create the products and add the images upon creating the products? And canāt this to work and some help would be very awesome!
