- Posts: 75
- Thank you received: 1
set defaults for Linked files when importing
13 years 4 months ago #103252
by spotstv
set defaults for Linked files when importing was created by spotstv
We have a list of 700 products and many have specifications in PDF format. So far we have manually linked them in using the Files option in Product details. However, when we export and re-import as a CSV file the links are lost and the settings messed up See before and after screenshots.
Is there a way to either set as default Free download, Download Number Limited and Name? OR specify them as columns in the import CSV?
We don't often need to export and re-import but it is very handy.
Regards
Tim
Is there a way to either set as default Free download, Download Number Limited and Name? OR specify them as columns in the import CSV?
We don't often need to export and re-import but it is very handy.
Regards
Tim
Please Log in or Create an account to join the conversation.
13 years 4 months ago #103313
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Replied by Jerome on topic set defaults for Linked files when importing
Hi,
The export/import system does not handle all options of product files.
If you want to change the default values, you have to edit the helper import and see the function "_insertFiles".
You will see that the SQL query insert several values but not all values.
If you want to set the default values, you can specify them directly in the database. By setting the "default" value for the column.
Otherwise, you can update the query in the helper import.
Regards,
The export/import system does not handle all options of product files.
If you want to change the default values, you have to edit the helper import and see the function "_insertFiles".
You will see that the SQL query insert several values but not all values.
Code:
INSERT IGNORE INTO #__hikashop_file (`file_name`,`file_description`,`file_path`,`file_type`,`file_ref_id`,`file_ordering`)
If you want to set the default values, you can specify them directly in the database. By setting the "default" value for the column.
Otherwise, you can update the query in the helper import.
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Please Log in or Create an account to join the conversation.
13 years 1 month ago #118994
by Flooder
Replied by Flooder on topic set defaults for Linked files when importing
It could be nice to import file_free_download field in the CSV by default in Hikashop.
Please Log in or Create an account to join the conversation.
13 years 1 month ago #119007
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Replied by Jerome on topic set defaults for Linked files when importing
Hi,
Yes, it will and it is already in our TODO list.
It will be done with a re-factoring of the import system but I can't give any date for that.
Regards,
Yes, it will and it is already in our TODO list.
It will be done with a re-factoring of the import system but I can't give any date for that.
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: Flooder
Please Log in or Create an account to join the conversation.
Time to create page: 0.190 seconds