paulocoelho Posted June 24, 2023 Share Posted June 24, 2023 Hello, I have this invoice program called Keyinvoice, their API already updates the stock on "simple products" but im trying to configure it to add stock to products with combinations. I dont want it to create new combinations, just want it to updade the stock on already existing ones. Example: Product1 from keyinvoice has stock:1 Product1 from prestashop, with color red change the stock to 1. This is the code that lets me update the stock on products without combinations if ($kproduct->HasStocks) { StockAvailable::setQuantity($product->id, 0, $kproduct->Stock); } Any help? Link to comment Share on other sites More sharing options...
ps8modules Posted June 29, 2023 Share Posted June 29, 2023 Hi, the first parameter is the product id, the second parameter is the combination id, and the third parameter is the count. StockAvailable::setQuantity($product_id, $product_attribute_id, $quantity) Link to comment Share on other sites More sharing options...
paulocoelho Posted June 30, 2023 Author Share Posted June 30, 2023 8 hours ago, ps8moduly.cz said: StockAvailable::setQuantity($product_id, $product_attribute_id, $quantity) Tried like this and it diddnt work. It stopped updating the product at all. Link to comment Share on other sites More sharing options...
ps8modules Posted June 30, 2023 Share Posted June 30, 2023 This was just a sample of the values you should fill in. Link to comment Share on other sites More sharing options...
ps8modules Posted June 30, 2023 Share Posted June 30, 2023 Sorry, but you have multiple threads for one issue. If you look at the ps_stock_available table, you will find out how the calculation works. An id_product_attribute that is 0 is the sum of all id_product_attributes for that product. Link to comment Share on other sites More sharing options...
paulocoelho Posted June 30, 2023 Author Share Posted June 30, 2023 I have one issue with two ways to aproach it, Change the code of an API, or configure a module with a Filter (without atributes). Thats why i opened 2 threads, because i have 2 diferent questions. If i find a solution for one of the threads the other problem might be solved. "An id_product_attribute that is 0 is the sum of all id_product_attributes for that product" I get this, this is why the code only edits stock for simple products. My issue is, how can i code this to edit the stock inside the combination? Or Do you have any solution for the Filter module thread? Link to comment Share on other sites More sharing options...
ps8modules Posted June 30, 2023 Share Posted June 30, 2023 I understand clearly. Your invoice program is like your warehouse system. Can he send the product name, product id and possibly also the attribute name? Link to comment Share on other sites More sharing options...
ps8modules Posted June 30, 2023 Share Posted June 30, 2023 What is the problem with modifying the API? Can you make the API code available? Link to comment Share on other sites More sharing options...
ps8modules Posted June 30, 2023 Share Posted June 30, 2023 Is this an extension? https://www.keyinvoice.com/plugins.php Link to comment Share on other sites More sharing options...
ps8modules Posted June 30, 2023 Share Posted June 30, 2023 In the export, it can send attributes in the options tag. And why can't you send them in the import as well? Why use a service that can basically do 50%? I'm sorry, but I can't help you with that, because s3 would go against the logic of the warehouse in Prestashop. Can't be bypassed. Link to comment Share on other sites More sharing options...
paulocoelho Posted June 30, 2023 Author Share Posted June 30, 2023 I suspected it couldnt be done this way. Do you know if there is a way to code the product attributes stock in prestashop to always show the same value as the product stock? Lets say i export from keyinvoice the product without attributes with product id "1234" with the Stock of 10un I import it to Prestashop, it will check the product ID and if it exists, updates the product stock. If i can get the attribute stock to be the same as the product stock, my problem would be (kind of) solved. Do you think it could be done? Link to comment Share on other sites More sharing options...
ps8modules Posted July 1, 2023 Share Posted July 1, 2023 Hi. If I understand correctly, if you import 10un for a product, it will be red 10un, yellow 10un, blue 10un... And when 1un is sold, it will again be red 9un, yellow 9un, blue 9un... Link to comment Share on other sites More sharing options...
paulocoelho Posted July 1, 2023 Author Share Posted July 1, 2023 Yes, that would solve my problem. Do you have any solution? Link to comment Share on other sites More sharing options...
ps8modules Posted July 1, 2023 Share Posted July 1, 2023 (edited) Hi. Yes, I have already programmed such a solution or module for my customer. It included the option to choose in the product settings whether the attributes should be calculated and matched as a separate product. Compatible with Prestashop 1.5 and 1.6. I would have to modify for 1.7 and 8.x Edited July 1, 2023 by ps8moduly.cz (see edit history) Link to comment Share on other sites More sharing options...
paulocoelho Posted July 3, 2023 Author Share Posted July 3, 2023 Can this module create filters without adding attributes? What I need is for the product to be simple, but I can add personalised filters. On 7/1/2023 at 7:25 PM, ps8moduly.cz said: Hi. Yes, I have already programmed such a solution or module for my customer. It included the option to choose in the product settings whether the attributes should be calculated and matched as a separate product. Compatible with Prestashop 1.5 and 1.6. I would have to modify for 1.7 and 8.x Link to comment Share on other sites More sharing options...
ps8modules Posted July 3, 2023 Share Posted July 3, 2023 (edited) What filters? The module according to settings will update the count for all combinations according to the main product. It works in the background, whenever the Prestashop function is called to change the number in stock available. This means that if someone buys a combination of, for example, red, the others, for example, green and blue, will have the same number. In this case, the total sum of the attributes will be the same as the number in the combination. In short, it's the same as you need. Combinations: 9 +9 +9 = 9 !!! Product: 9 = Combinations: 9 + 9 + 9 !!! Otherwise, it will be necessary to create separate products from the combinations. Edited July 3, 2023 by ps8moduly.cz (see edit history) Link to comment Share on other sites More sharing options...
ps8modules Posted July 3, 2023 Share Posted July 3, 2023 My module is intended for those who sell ash products and have them modified with combinations.Example: My company makes wooden toys, for example a train with a wagon. He has 9 unpainted trains with wagons in stock. Someone orders red wheels and a green machine and a yellow wagon. So 1 is subtracted from the warehouse for all combinations, because one "semi-finished" machine with a wagon leaves the warehouse. Link to comment Share on other sites More sharing options...
paulocoelho Posted July 3, 2023 Author Share Posted July 3, 2023 This will solve my problem if the API puts the stock in this "Quantity" field. How can i test it? Link to comment Share on other sites More sharing options...
ps8modules Posted July 3, 2023 Share Posted July 3, 2023 Unable to test. Link to comment Share on other sites More sharing options...
paulocoelho Posted July 3, 2023 Author Share Posted July 3, 2023 can you make it work ? Link to comment Share on other sites More sharing options...
ps8modules Posted July 3, 2023 Share Posted July 3, 2023 Hi. I'm sorry, but I have multiple projects at the moment and it's not worth it for me to spend several hours modifying a module for higher versions of Prestashop and one sale. I'll get to it in 14 days at the earliest. Unfortunately, I don't even know about any such module. Hopefully someone else can advise. There are a lot of developers and agencies here. Link to comment Share on other sites More sharing options...
paulocoelho Posted July 7, 2023 Author Share Posted July 7, 2023 Ok, for now, it seems i dont have other option, so i will wait for your edit. Can you provide the 1.6 version, or a demo? i can try to install 1.6 just to test it a bit, to see if with the API can send the stock info to the right place. Link to comment Share on other sites More sharing options...
ps8modules Posted July 7, 2023 Share Posted July 7, 2023 Hi, on monday the module will be available. https://ps8moduly.cz/moduly/28-aktualizujte-mnozstvi-kombinaci-podle-mnozstvi-produktu Link to comment Share on other sites More sharing options...
paulocoelho Posted July 10, 2023 Author Share Posted July 10, 2023 On 7/7/2023 at 9:56 AM, ps8moduly.cz said: Hi, on monday the module will be available. https://ps8moduly.cz/moduly/28-aktualizujte-mnozstvi-kombinaci-podle-mnozstvi-produktu It works, thanks. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now