[Skip to main content](#vessel-content) # Changing Products Shipping Price with CSV ## - **[pigletdcat](/forum/user/34934-pigletdcat "View pigletdcat's Profile")** - [![pigletdcat's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/cat.png)](/forum/user/34934-pigletdcat "View pigletdcat's Profile") Topic Author - [ Offline](/forum/user/34934-pigletdcat) Less More - Posts: 6 - Thank you received: 0 - - 11 years 11 months ago [\#181014](#181014) by [pigletdcat](/forum/user/34934-pigletdcat "View pigletdcat's Profile") *[Changing Products Shipping Price with CSV](/forum/28-shipping-methods/873227-changing-products-shipping-price-with-csv#181014 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome 38.0.2125 I was wondering if this can be done. I have hundreds of products that it would be troublesome to change their shipping price one by one. Example, product A1 to A100's shipping price from 3$ will be changed to $2.50. Can anyone tell me if this is possible? Where in the exported CSV file of products can I change the value for shipping price? Thank you.")* was created by *[pigletdcat](/forum/user/34934-pigletdcat "View pigletdcat's Profile")* -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome 38.0.2125 I was wondering if this can be done. I have hundreds of products that it would be troublesome to change their shipping price one by one. Example, product A1 to A100's shipping price from 3$ will be changed to $2.50. Can anyone tell me if this is possible? Where in the exported CSV file of products can I change the value for shipping price? Thank you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvODczMjI3LWNoYW5naW5nLXByb2R1Y3RzLXNoaXBwaW5nLXByaWNlLXdpdGgtY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 11 years 11 months ago [\#181055](#181055) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Changing Products Shipping Price with CSV](/forum/28-shipping-methods/873227-changing-products-shipping-price-with-csv#181055 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome 38.0.2125 I was wondering if this can be done. I have hundreds of products that it would be troublesome to change their shipping price one by one. Example, product A1 to A100's shipping price from 3$ will be changed to $2.50. Can anyone tell me if this is possible? Where in the exported CSV file of products can I change the value for shipping price? Thank you.")* Hi, No this is not yet possible. As the shipping prices are not stored in the product table, it's not possible to manage this price using the mass actions for example. But by creating a new mass action plugin, this feature can be added. [ www.hikashop.com/support/support/documen...s-action-plugin.html](http://www.hikashop.com/support/support/documentation/168-create-you-own-mass-action-plugin.html) I add it on our TODO list. The following user(s) said Thank You: [pigletdcat](/forum/user/34934-pigletdcat "View pigletdcat's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvODczMjI3LWNoYW5naW5nLXByb2R1Y3RzLXNoaXBwaW5nLXByaWNlLXdpdGgtY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[pigletdcat](/forum/user/34934-pigletdcat "View pigletdcat's Profile")** - [![pigletdcat's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/cat.png)](/forum/user/34934-pigletdcat "View pigletdcat's Profile") Topic Author - [ Offline](/forum/user/34934-pigletdcat) Less More - Posts: 6 - Thank you received: 0 - - 11 years 11 months ago - 11 years 11 months ago [\#181176](#181176) by [pigletdcat](/forum/user/34934-pigletdcat "View pigletdcat's Profile") Replied by *[pigletdcat](/forum/user/34934-pigletdcat "View pigletdcat's Profile")* on topic *[Changing Products Shipping Price with CSV](/forum/28-shipping-methods/873227-changing-products-shipping-price-with-csv#181176 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome 38.0.2125 I was wondering if this can be done. I have hundreds of products that it would be troublesome to change their shipping price one by one. Example, product A1 to A100's shipping price from 3$ will be changed to $2.50. Can anyone tell me if this is possible? Where in the exported CSV file of products can I change the value for shipping price? Thank you.")* Thanks for telling me. Well, I hope that implementing it will be done soon. It is a pain to change everything, you know? But can you teach me or set me an easy example on how to implement it a mass action that you told me? Last edit: 11 years 11 months ago by [pigletdcat](/forum/user/34934-pigletdcat "View pigletdcat's Profile"). Reason: Asking for an example Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvODczMjI3LWNoYW5naW5nLXByb2R1Y3RzLXNoaXBwaW5nLXByaWNlLXdpdGgtY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 11 months ago [\#181228](#181228) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Changing Products Shipping Price with CSV](/forum/28-shipping-methods/873227-changing-products-shipping-price-with-csv#181228 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome 38.0.2125 I was wondering if this can be done. I have hundreds of products that it would be troublesome to change their shipping price one by one. Example, product A1 to A100's shipping price from 3$ will be changed to $2.50. Can anyone tell me if this is possible? Where in the exported CSV file of products can I change the value for shipping price? Thank you.")* The simplest will be to export/import as a CSV the hikashop_shipping_prices table data via your phpmyadmin so that you can easily open it in excel and modify the prices like that. The following user(s) said Thank You: [pigletdcat](/forum/user/34934-pigletdcat "View pigletdcat's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvODczMjI3LWNoYW5naW5nLXByb2R1Y3RzLXNoaXBwaW5nLXByaWNlLXdpdGgtY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[pigletdcat](/forum/user/34934-pigletdcat "View pigletdcat's Profile")** - [![pigletdcat's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/cat.png)](/forum/user/34934-pigletdcat "View pigletdcat's Profile") Topic Author - [ Offline](/forum/user/34934-pigletdcat) Less More - Posts: 6 - Thank you received: 0 - - 11 years 11 months ago [\#181268](#181268) by [pigletdcat](/forum/user/34934-pigletdcat "View pigletdcat's Profile") Replied by *[pigletdcat](/forum/user/34934-pigletdcat "View pigletdcat's Profile")* on topic *[Changing Products Shipping Price with CSV](/forum/28-shipping-methods/873227-changing-products-shipping-price-with-csv#181268 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome 38.0.2125 I was wondering if this can be done. I have hundreds of products that it would be troublesome to change their shipping price one by one. Example, product A1 to A100's shipping price from 3$ will be changed to $2.50. Can anyone tell me if this is possible? Where in the exported CSV file of products can I change the value for shipping price? Thank you.")* I found what you're talking about in phpmyadmin in my Cpanel. But I am puzzled on what to do exactly. If I am to change the shipping price/fee of a single product, is it going to show here? - [ ![hika_db.jpg](/forum/attachment/20907) ](/forum/attachment/20907 "hika_db.jpg") [ ](/forum/attachment/20907?download=1 "hika_db.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvODczMjI3LWNoYW5naW5nLXByb2R1Y3RzLXNoaXBwaW5nLXByaWNlLXdpdGgtY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 11 months ago [\#181285](#181285) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Changing Products Shipping Price with CSV](/forum/28-shipping-methods/873227-changing-products-shipping-price-with-csv#181285 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome 38.0.2125 I was wondering if this can be done. I have hundreds of products that it would be troublesome to change their shipping price one by one. Example, product A1 to A100's shipping price from 3$ will be changed to $2.50. Can anyone tell me if this is possible? Where in the exported CSV file of products can I change the value for shipping price? Thank you.")* Yes. As you can see there is only one shipping product price in there with the shipping price in the shipping_price_value column. And you have the corresponding product id in the shipping_price_ref_id So if you want to add a shipping price for another product, you can add a copy of that same entry and just change the shipping_price_value and the shipping_price_ref_id for the other product. The following user(s) said Thank You: [pigletdcat](/forum/user/34934-pigletdcat "View pigletdcat's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvODczMjI3LWNoYW5naW5nLXByb2R1Y3RzLXNoaXBwaW5nLXByaWNlLXdpdGgtY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[pigletdcat](/forum/user/34934-pigletdcat "View pigletdcat's Profile")** - [![pigletdcat's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/cat.png)](/forum/user/34934-pigletdcat "View pigletdcat's Profile") Topic Author - [ Offline](/forum/user/34934-pigletdcat) Less More - Posts: 6 - Thank you received: 0 - - 11 years 10 months ago [\#182331](#182331) by [pigletdcat](/forum/user/34934-pigletdcat "View pigletdcat's Profile") Replied by *[pigletdcat](/forum/user/34934-pigletdcat "View pigletdcat's Profile")* on topic *[Changing Products Shipping Price with CSV](/forum/28-shipping-methods/873227-changing-products-shipping-price-with-csv#182331 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome 38.0.2125 I was wondering if this can be done. I have hundreds of products that it would be troublesome to change their shipping price one by one. Example, product A1 to A100's shipping price from 3$ will be changed to $2.50. Can anyone tell me if this is possible? Where in the exported CSV file of products can I change the value for shipping price? Thank you.")* I think I will try and experiment on this first on a dummy site before applying this to our website. I don't want to get sacked because instead of troubleshooting, I just caused trouble. Thank you though. Hope you create the fix. ![^_^](/anime.gif "^_^") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvODczMjI3LWNoYW5naW5nLXByb2R1Y3RzLXNoaXBwaW5nLXByaWNlLXdpdGgtY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Bernhard7](/forum/user/36875-bernhard7 "View Bernhard7's Profile")** - [![Bernhard7's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36875-bernhard7 "View Bernhard7's Profile") - [ Offline](/forum/user/36875-bernhard7) Less More - Posts: 40 - Thank you received: 1 - - 10 years 3 months ago [\#246331](#246331) by [Bernhard7](/forum/user/36875-bernhard7 "View Bernhard7's Profile") Replied by *[Bernhard7](/forum/user/36875-bernhard7 "View Bernhard7's Profile")* on topic *[Changing Products Shipping Price with CSV](/forum/28-shipping-methods/873227-changing-products-shipping-price-with-csv#246331 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome 38.0.2125 I was wondering if this can be done. I have hundreds of products that it would be troublesome to change their shipping price one by one. Example, product A1 to A100's shipping price from 3$ will be changed to $2.50. Can anyone tell me if this is possible? Where in the exported CSV file of products can I change the value for shipping price? Thank you.")* Hi, I have the same Problem. you added this to your TODO list. is the TODO list official? when can we expect this Feature to allow Import of the shipping_price for products? Thank you, Best regards, Bernhard Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvODczMjI3LWNoYW5naW5nLXByb2R1Y3RzLXNoaXBwaW5nLXByaWNlLXdpdGgtY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 10 years 3 months ago [\#246341](#246341) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Changing Products Shipping Price with CSV](/forum/28-shipping-methods/873227-changing-products-shipping-price-with-csv#246341 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome 38.0.2125 I was wondering if this can be done. I have hundreds of products that it would be troublesome to change their shipping price one by one. Example, product A1 to A100's shipping price from 3$ will be changed to $2.50. Can anyone tell me if this is possible? Where in the exported CSV file of products can I change the value for shipping price? Thank you.")* Hi, Official ? It is written internally on a server in our company, so it is as official as you can get. It is however not public. We don't have a date when we would release that feature. We didn't start working on it yet as we are working on other things. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI4LXNoaXBwaW5nLW1ldGhvZHMvODczMjI3LWNoYW5naW5nLXByb2R1Y3RzLXNoaXBwaW5nLXByaWNlLXdpdGgtY3N2P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.361 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)