nicoX Posted December 18, 2018 Share Posted December 18, 2018 I want a CSV based on categories, say Jeans, which I want to import to set the weight of Jeans, how is this done? Any template? Link to comment Share on other sites More sharing options...
RogueWaveLimited Posted December 18, 2018 Share Posted December 18, 2018 I don't believe you can set the weight of a category. You need to set the weight of each individual product. Link to comment Share on other sites More sharing options...
Haumea Posted December 18, 2018 Share Posted December 18, 2018 Maybe you can set the weight for all product with a set category default value. Link to comment Share on other sites More sharing options...
nicoX Posted December 18, 2018 Author Share Posted December 18, 2018 Yes even better with id's. How is this done? Any template? Link to comment Share on other sites More sharing options...
Haumea Posted December 18, 2018 Share Posted December 18, 2018 You don't need to have any other information? Just change the price of products in a specific category? Otherwise you can just run a SQL query. Link to comment Share on other sites More sharing options...
nicoX Posted December 18, 2018 Author Share Posted December 18, 2018 (edited) 22 minutes ago, Haumea said: You don't need to have any other information? Just change the price of products in a specific category? Otherwise you can just run a SQL query. No I need to add weight for products for DHL shipping charges. For example I want to add 200 gram for t-shirts, using a CSV file. Edited December 18, 2018 by nicoX (see edit history) Link to comment Share on other sites More sharing options...
nicoX Posted December 18, 2018 Author Share Posted December 18, 2018 Ok this does categories? https://stackoverflow.com/questions/42063202/prestashop-1-6-query-to-add-product-weight-to-all-items&ved=2ahUKEwjrjK-uqarfAhWFMd8KHTGqApMQjjgwAHoECAMQAQ&usg=AOvVaw2NCvCTEVExGMaMXhloNLh5 Link to comment Share on other sites More sharing options...
Haumea Posted December 18, 2018 Share Posted December 18, 2018 Yes, but it is still not a CSV file. For CSV file you have to create one with id_product, weight and then do a foreach. Still i don't understand why you have to use a CSV if you only have to update weight and it is not directly connected to the DHL importing function. Link to comment Share on other sites More sharing options...
nicoX Posted December 18, 2018 Author Share Posted December 18, 2018 I don't know how to do a sql query but will research it. Link to comment Share on other sites More sharing options...
Haumea Posted December 18, 2018 Share Posted December 18, 2018 The SQL query you referred to will work. You can run it directly in the database if you have access to it, otherwise just create a PHP file with the query and navigate to it in order to run it. Then delete the file. 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