set defaults for Linked files when importing

  • Posts: 75
  • Thank you received: 1
11 years 5 months ago #103252

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

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 26151
  • Thank you received: 4027
  • MODERATOR
11 years 5 months ago #103313

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.

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.

  • Posts: 263
  • Thank you received: 11
11 years 2 months ago #118994

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.

  • Posts: 26151
  • Thank you received: 4027
  • MODERATOR
11 years 2 months ago #119007

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,

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.073 seconds
Powered by Kunena Forum