REST API /products endpoint does not return all products

I’m trying to list all products via the REST API. I have 1195 products in my store, but the API is consistently only returning 849 of them, and it’s the same ones that are left out every time.

My requests look like this:`

(Repeated for all subsequent pages, of course.)

I have tried specifying lists of SKUS and using a filter group with the in operator, rather than just leaving it unspecified, but the same products are still missing from the result.

However, if I query for the missing products individually (i.e. /rest/V1/products/123) it works no problem.

I’ve looked over the products that are being left out to try and determine whether there’s some feature common to them that might be causing them to be left out, but I can’t find anything. Some are enabled and some are disabled, some are in stock and some are out of stock, they’re attached to various different categories, etc.

Has anybody else ever run into an issue like this? I’m on Magento 2.3.6, for reference.

magento 1.9 – How to assign custom options to auto added products trough observer?

Im stuck on assign custom options to auto added products trough observer.

Im able to assign custom option to the main product which is added by frontend:

            $event = $observer->getEvent();
            $item = $event->getQuoteItem();
            $product = $item->getProduct();
            $quote = $item->getQuote();

            $configRelation = array(
                'options' => array(
                     'label' => 'relationkey',
                     'value' => $this->generateRandomString(5, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ')

            $item->addOption(new Varien_Object(
                    'product' => $product,
                    'code' => 'additional_options',
                    'value' => serialize($configRelation)


This working well, but then on next step Im adding a additional product:

                $additionalProduct = Mage::getModel('catalog/product')->load($idofexistingProduct);

                $params = new Varien_Object(
                        'product' => $additionalProduct,
                        'code' => 'additional_options',
                        'value' => serialize($configRelation),
                        'qty' => 1

                $quote->addProduct($additionalProduct, $params);

This one adds the $additionalProduct well, but I dont have custom option like on the main product.

I tried to init the cart model resource and addProduct without quote, but this causing a timeout, I think its entering a endless loop because of the observer.

The main reason for this is to relate multiple products with the main product.

custom taxonomy – update attribute of specific products in woocommerce

I need to change the value of all product attributes that have a specific attribute with a specific value.
for example, I have 10 phones with Ram(attribute): 64 GiB (attribute value) and 5 Phone with Ram(attribute): 64 GB (attribute value).
I need to change all products with Ram: 64 GiB to Ram: 64 GB, So there will be no 64GiB anymore, I tried the below code and but they didn’t work

$product_id = 14352; //some product id
$storage = get_the_terms($product_id, 'pa_internal-storage');
$newStorage = '64GB';
update_post_meta($product_id, 'pa_internal-storage', $newStorage);

magento2 – Importing existing products: Integrity constraint violation: 1062 Duplicate Entry

I have been importing existing products to a local environment through the admin dashboard. I realized that many of the products I imported didn’t include their attributes, so I went back to make sure they were included by changing the ‘Multiple value separator’ to a pipe. Now though, when I import I get the following error:

General system exception happened
Additional data:
SQLSTATE(23000): Integrity constraint violation: 1062 Duplicate entry 'sauces-rubs/healthy-choices/gluten-free-default-category/healthy' for key 'url_rewrite.URL_REWRITE_REQUEST_PATH_STORE_ID', query was: INSERT INTO `url_rewrite` (`redirect_type`,`is_autogenerated`,`metadata`,`description`,`store_id`,`entity_type`,`entity_id`,`request_path`,`target_path`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

I have deleted all products and categories, I have wiped the url_rewrites table clean, and I have attempted to regenerate them using this module. What am I missing? I am new to Magento, so please let me know if I need to include more information, but this is all that I am aware of at the moment.

stock – Salable Quantity is greater than quantity with some products

on some cases my salable quantity is greater than my quantity, not for all product but for example to 10 products on 1000.
I could not figure out why, I also tried to delete the product and insert it again but the problem persists (it is probably related to the SKU). is there a way to how to decrease salable quantity without placing order?

eCommerce and fulfillment for $6-$10 products?


We are getting ready to launch a product that eventually will be in retail but trying to see if we can cost-effectively sell directly to consumers. Our product is paper-based and should be priced to the consumer between $6 to $10 depending on the configuration.

We tried pricing this out leveraging Amazon as the store and fulfillment and just can’t make the numbers work in addition to be confused about their inventory costs etc.

Can anyone steer us toward vendor(s) to work with on the estore and fufillment side? We have a prototype store built on GoDaddy but not sure if they interface with the fulfillment options we want to consider.

We aren’t sure marketplace stories like Amazon ort Etsy will be worth the extra costs as we believe we are going to need to be doing all the demand generation and our product is a new category.