Resolved Product ordering after new import

New Reply Added

tharuna replied to the discussion Product ordering after new import














Hello,


This is a notification to let you know that tharuna has replied to the discussion on the site. You may find the snippet of the reply below:








Hello Marcel,

You can load the attached patch file to get multiple values separated by | for product_ordering field in export.




Attachments:







patch_vm_2019_08_09.zip






ed.require(['edq', 'easydiscuss', 'jquery.fancybox'], function($, EasyDiscuss) {

// Bind the delete attachment buttons
var attachmentWrapper = $('[data-ed-attachment-item]');

$(document)
.on('click', '[data-ed-attachment-delete]', function() {

var id = $(this).parents(attachmentWrapper.selector).data('id');
var parent = $(this).parents(attachmentWrapper.selector);

EasyDiscuss.dialog({
content: EasyDiscuss.ajax('site/views/attachments/confirmDelete', { "id": id }),
bindings: {
"{submitButton} click": function() {

// Remove the attachment
parent.remove();

// When the delete button is clicked, call the ajax method to remove the attachment
EasyDiscuss.ajax('site/views/attachments/delete', {
"id": id
}).done(function() {

// Hide the dialog
EasyDiscuss.dialog().close();
});
}
}
})
});

// Apply fancybox
var attachmentPreview = $('[data-ed-attachment-preview]');

attachmentPreview.fancybox({
type: 'image',
wrapCSS: 'fancy--ed-image',

helpers: {
overlay: null
}
});

});













Read this discussion
















This email was sent to you, because you have subscribed to the discussion.

To unsubscribe, please click here. Manage subscriptions.

Hello Marcel,
You can load the attached patch file to get multiple values separated by | for product_ordering field in export.

Hello Marcel,
Apologies, i was talking about import in my previous reply. I see you have issue with export. We do not have multiple values support in export. Will look into it and get back with an update.

Hello Marcel,
product_ordering should work for your values 5|2 because we do support multiple values for product_ordering field. Is it not working for you?

Great!
But now the final thing is this;

In the export file, there is this;
product_sku;product_ordering;category_id
111200077;5;1|14

But it should be:
product_sku;product_ordering;category_id
111200077;5|2;1|14

so, in cat. ID 1, the ordering is 5
and in cat ID 14 the ordering is 2

How can I get ordering "2" for cat ID 14 in the export?

Marcel,

Actually I did not like it so much The system got stuck in a loop All should be cleared out now.

Hello Marcel,
Glad to know that you found it.

You must like it very very very much!

Found it....
I needed to export and import category ID...

Tharuna!
I was busy but now I need to solve this. To make things very clear, I created a jpg. Please check if it's clear like this

Hello Marcel,
Are you looking at importing custom fields ordering or product ordering? They are two different things and seems like there is a confusion with the ordering you are doing.

Thanks Tharuna!
I exported and that file seems ok. Then I imported it (on a different domain (server13) but it does not change the custom order
Can you take a look?

Marcel

Hello,
Ok, pordering field is for ordering of child products for a parent product and can be seen in virtuemart_products table. product_ordering gets the ordering of a product in a category which is from virtuemart_product_categories.

This is with the pordering

product_sku;product_ordering;pordering
111200278;44;0
25000303;51;0
25000305;17;0
25000306;16;0
25000307;15;0

The value is "0" for that field.

No

This;
product_sku;product_ordering
111200278;44

And that's good I think because I compared the value in VM backend and the number in the CSV.