Hi everyone, help me please clarify how i can declare Default values for some rows in exported XLS.
For example i need in Products tab:
requires shipping = always yes
language_id = always 1
store_ids = always 1
subtract = always true
In Catalog Tab:
language_id = always 1
store_ids = always 1
status enabled = [/b]always true
BTW: Excel can Hide and UnHide Rows, So we have any change to hide some rows for minify Rows view
at Excel? And last question - how change default sort order?
i always need change sort order by category_id in Excel, its crazy things if make more changes imports and and exports.
Well these are excel issues so hopefully an excel guru will respond to this 
The Finnish OpenCart Forum
"Real programmers don't document. If it was hard to write, it should be hard to understand."
If you leave these columns empty, it will use the following default values during an Import:ravex wrote:Hi everyone, help me please clarify how i can declare Default values for some rows in exported XLS.
For example i need in Products tab:
requires shipping = always yes
language_id = always 1
store_ids = always 1
subtract = always true
In Catalog Tab:
language_id = always 1
store_ids = always 1
status enabled = [/b]always true
BTW: Excel can Hide and UnHide Rows, So we have any change to hide some rows for minify Rows view
at Excel? And last question - how change default sort order?
i always need change sort order by category_id in Excel, its crazy things if make more changes imports and and exports.
Products worksheet:
requires shipping ='true'
language_id = '1'
store_ids = ''
subtract = 'true'
Categories worksheet:
language_id = '1'
store_ids = ''
status enabled = 'true'
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
JNeuhoff. its only example and i wish to try make few tweaks
BTW: in my case
status enabled = empty (not true)
JAY6390, Can you point me at target lines of code?
i'll try make some changes, but without any positive results. each of this parameters are in few plaсes of code and I can't find the needful
BTW: in my case
status enabled = empty (not true)
JAY6390, Can you point me at target lines of code?
i'll try make some changes, but without any positive results. each of this parameters are in few plaсes of code and I can't find the needful
Sure. The file you're looking for is
Then search for:
You should be able to work it out from there which is which variable
Code: Select all
/admin/model/tool/export.phpCode: Select all
function uploadCategories
function uploadDiscounts
function uploadImages
function uploadOptions
function uploadProducts
function uploadSpecials
Who is online
Users browsing this forum: No registered users and 11 guests
