[Skip to main content](#vessel-content)

#   Manual product ordering not retained on import?

##

- **[CardOneConcepts](/forum/user/32028-cardoneconcepts "View CardOneConcepts's Profile")**
- [![CardOneConcepts's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar32028.png)](/forum/user/32028-cardoneconcepts "View CardOneConcepts's Profile") Topic Author
- [ Offline](/forum/user/32028-cardoneconcepts)
- We Only Do Well The Things We Love To Do!

Less More

- Posts: 35
- Thank you received: 1
-
-
- [](http://cardoneconcepts.com)
-

11 years 4 months ago [\#206276](#206276) by [CardOneConcepts](/forum/user/32028-cardoneconcepts "View CardOneConcepts's Profile")  *[Manual product ordering not retained on import?](/forum/37-import-export-csv-xls/877791-manual-product-ordering-not-retained-on-import#206276 "-- HikaShop version -- : HikaShop Business: 2.4.0 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.13 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : No Errors  Hello,  I have all my product pages set up to display products on the front-end by the &quot;Ordering&quot; option in the product parameters &quot;ordering field&quot;. i have it set up this way so that the products can be manually sorted to display in a specific order on the front-end, see attached screenshot to see how I have the settings set up. This works great and I am able to manually order products in the back-end and it gets reflected on the front-end as expected.  However, when I perform a product import all my manual ordering that was set up is not retained and all the products get reordered on the front-end and I must go in and manually re-order them after an import?  Am I missing something here? Why does my manual product ordering get wiped out when I try to update products with a product import file? Could you help me figure out how to retain my manual ordering configuration when updating products through the product import function?  I am also attaching a sample import file to inspect as well if that helps. From my own tests it appears as though the products always get re-ordered by product ID?  Thank you for your time!")* was created by *[CardOneConcepts](/forum/user/32028-cardoneconcepts "View CardOneConcepts's Profile")*

-- HikaShop version -- : HikaShop Business: 2.4.0
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.3.13
-- Browser(s) name and version -- : Chrome
-- Error-message(debug-mod must be tuned on) -- : No Errors

Hello,

I have all my product pages set up to display products on the front-end by the "Ordering" option in the product parameters "ordering field". i have it set up this way so that the products can be manually sorted to display in a specific order on the front-end, see attached screenshot to see how I have the settings set up. This works great and I am able to manually order products in the back-end and it gets reflected on the front-end as expected.

However, when I perform a product import all my manual ordering that was set up is not retained and all the products get reordered on the front-end and I must go in and manually re-order them after an import?

Am I missing something here? Why does my manual product ordering get wiped out when I try to update products with a product import file? Could you help me figure out how to retain my manual ordering configuration when updating products through the product import function?

I am also attaching a sample import file to inspect as well if that helps. From my own tests it appears as though the products always get re-ordered by product ID?

Thank you for your time!

[ ![ordering.png](/forum/attachment/25172) ](/forum/attachment/25172 "ordering.png")

*This attachment is hidden for guests.
Please log in or register to see it.*

---

Thank you for your time!

Sincerely,
Brandon Cardone, Card One Concepts

- [ ![ordering.png](/forum/attachment/25172) ](/forum/attachment/25172 "ordering.png") [ ](/forum/attachment/25172?download=1 "ordering.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Nzc3OTEtbWFudWFsLXByb2R1Y3Qtb3JkZXJpbmctbm90LXJldGFpbmVkLW9uLWltcG9ydD90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86560
- Thank you received: 14307
-
-

11 years 4 months ago [\#206397](#206397) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Manual product ordering not retained on import?](/forum/37-import-export-csv-xls/877791-manual-product-ordering-not-retained-on-import#206397 "-- HikaShop version -- : HikaShop Business: 2.4.0 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.3.13 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : No Errors  Hello,  I have all my product pages set up to display products on the front-end by the &quot;Ordering&quot; option in the product parameters &quot;ordering field&quot;. i have it set up this way so that the products can be manually sorted to display in a specific order on the front-end, see attached screenshot to see how I have the settings set up. This works great and I am able to manually order products in the back-end and it gets reflected on the front-end as expected.  However, when I perform a product import all my manual ordering that was set up is not retained and all the products get reordered on the front-end and I must go in and manually re-order them after an import?  Am I missing something here? Why does my manual product ordering get wiped out when I try to update products with a product import file? Could you help me figure out how to retain my manual ordering configuration when updating products through the product import function?  I am also attaching a sample import file to inspect as well if that helps. From my own tests it appears as though the products always get re-ordered by product ID?  Thank you for your time!")*

Hi,

In your CSV you have the categories and categories_ordering columns.
In the categories column, you have specified the ids of the categories of the products.
So the system will replace the links between the products and the categories with the new ones in your CSV. It will base itself on the categories_ordering column for the ordering.
So you have two possible solutions:
- You remove the categories and categories_ordering (and the other categories_ columns) from your CSV so that the links between the products and the categories are not updated when you import your CSV.
- You specify the ordering of the categories in the categories_ordering column.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Nzc3OTEtbWFudWFsLXByb2R1Y3Qtb3JkZXJpbmctbm90LXJldGFpbmVkLW9uLWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.090 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
