You have no items in your shopping cart.

Friday, October 4, 2024 11:03:56 AM

sort products in xml

Posted: 7 years ago

#2977 Quote

Mishiwaka

Posted: 7 years ago

#2977 Quote
Hi, I am trying to sort products in xml file, and can't understand the logic - how this order created ))) May be somebody already solved it?

Posted: 7 years ago

#2978 Quote

Mishiwaka

Posted: 7 years ago

#2978 Quote
Well, I will rephrase...
I need to sort products while xml created, is it possible?

Posted: 7 years ago

#2984 Quote

Support

Posted: 7 years ago

#2984 Quote
No, plugin doesn't have such feature.
Can you describe me how you see it?

By default plugin exports products by product's name.

If you need it now you can change the stored procedure FNS_FeedManager_ProductLoadAll
Example

select P.*
from Product P WITH (NOLOCK)
where P.Id in (select ProductId from #ExportProducts)
ORDER BY P.[Name] ASC


Posted: 7 years ago

#2986 Quote

Mishiwaka

Posted: 7 years ago

#2986 Quote
The issue is that facebook catalog now have the same structure like google feed file, except picture size wich is really easy to configure with your plugin, but it doesn't support sorting after import from fees, so I need to sort products by id ))) This could really good option to work with FB catalogs

Posted: 7 years ago

#2987 Quote

Mishiwaka

Posted: 7 years ago

#2987 Quote
*feed

Posted: 7 years ago

#2990 Quote

Support

Posted: 7 years ago

#2990 Quote
I'll think how to add this feature.

You can change the sore procedure now with new code.

select P.*
from Product P WITH (NOLOCK)
where P.Id in (select ProductId from #ExportProducts)
ORDER BY P.Id


Posted: 7 years ago

#2991 Quote

Mishiwaka

Posted: 7 years ago

#2991 Quote
Could you please be so kind and explain how to do it ? ))

Posted: 7 years ago

#2992 Quote

Support

Posted: 7 years ago

#2992 Quote
I help you. I'll made new .SQL file for you.

What NopCommenrce version do you use?

Posted: 7 years ago

#2995 Quote

Mishiwaka

Posted: 7 years ago

#2995 Quote
Oh! So good, thx.
I use 3.5

Posted: 7 years ago

#2996 Quote

Support

Posted: 7 years ago

#2996 Quote
I sent you the file by e-mail.

Powered by nopCommerce

Copyright © 2023 FoxNetSoft. All rights reserved