View Single Post
  #293  
Old 11-15-2011, 11:01 PM
Ted S Ted S is offline
 
Join Date: Dec 2003
Location: SoCal
Posts: 3,954
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by downloadsuk View Post
Hi Ted - I must admit, I am struggling with this. I can find the links, but I am not sure which variable I need to add in order for the product name to be added to the URL - using {vb:raw title} for example causes the URL to have a number of spaces in it - which is obviously messy.
The script doesn't do this, you'd have to either build it yourself or make a manual mapping through htaccess to trick things.

For example, you can edit the plugin to output a second variable, {vb:raw urltitle} which runs through the php function urlencode() first or which has spaces and special characters removed / converted.

Code:
$product['urltitle'] = str_replace(" ", "-", $product['title']); // spaces become dashes
$product['urltitle'] = preg_replace("/[^A-Za-z0-9\_\- ]/", '', $product['urltitle']); // removes anything but letters, numbers, dashes and underlines
Quote:
Originally Posted by downloadsuk View Post
Will you be adding the option for custom fields? It's the main thing holding me back from adding hundreds/thousands of products with the bulk upload.
Assuming the mod keeps picking up use, yes, we will be.

Quote:
Originally Posted by downloadsuk View Post
Also, speaking of the bulk upload - do you have any data mapping services you would recommend? It's taking me quite a long time to organise the data in Excel and then format it to the required XML format. I know you mentioned before that CSV upload wasn't an option - but this would be a million times easier.
CSV is a pain to parse as you're counting by the number of comma separated items, not the element names. That means you still have to build the structure, but if you mess up with a single column or special character, the row is skipped or, as is so often the case, gets brought in incorrectly.

I'm sure there's a tool that can convert out from CSV and over to XML easily.

Quote:
Originally Posted by downloadsuk View Post
Finally, I know we spoke before about mass editing - I'm concerned that with all the data being uploaded, it is likely to change on a regular basis - could an option be created whereby if a product is added with a matching SKU to a previous product, then it overwrites the previous fields?
Right now the XML importer throws away duplicates but we can certainly have it update records instead keying off of a UPC / SKU / title match.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01219 seconds
  • Memory Usage 1,778KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (4)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete