It is inconvenient to manually add a large number of business listings at once to a fresh installation of GoClixy. Inserting categories, locations, and listings one by one will take a long time especially when you have hundreds or thousands of such information. In such situations, you need a solution to automatically add all those listings to your Online Business Directory.
Note: For security reasons, it is the best practice to delete all existing imported files.
Create a excel file with the following fields:
Import the file and map fields to the appropriate columns.
After bulk import, visit Content->Categories and click on the Tweak Bulk Import tab in the upper right corner. Continue to click on the Submit button until you see a message:
There is nothing to update.
After listings import, visit Settings->Import/Export->Importer and click on the Bulk Import Tweak tab in the upper left corner. Select Listings as the module and enter the ids range. You can find ids information via Content->Listings. Click on the Submit button to organize the information, in other words, this will add your imported data to specific tables.
https://<YOUR DOMAIN URL>/<ADMIN STRING>/settings/migrate/bulk_import_tweak
To import bulk listings, login to the admin panel and go to Settings->Import/Export->Importer, fill the information as described below and click the Save & Exit button.
Recommended: If you have a slow Internet connection and the size of your file is larger than 5MB, then upload the file on your Hosting Server and type its name in the Specify File Name textbox.## NOTE: After purchase, download your license copy and you will find the sample import files and other useful instructions in the Documentation folder ##
The export option allows you to download the information from your existing website for backup and other purposes.
To download an existing exported file, click the file name under the File Name column.
To delete the exported data information, select the file by marking the checkbox to the left of the Data Exported column and click the Delete button.
To export bulk listings, login to the admin panel and visit Settings->Import/Export->Exporter, fill the information as described below and click the Save button.
Note: The username and password must be same for both databases.
public function location($slug, $city = null) { $id = (int)substr( $slug, strrpos( $slug, '-' ) + 1); $module = 'listings'; if(empty($id)) { if(!empty($city)) { $city = escape($city); $location = $this->db->where('slug', $city)->get('cities')->row(); if($location) { $slug = $location->slug . '-' . $location->id; $this->listings_model->category_location_tag_search(false, 'listings', 'cities', $this->session->userdata('search_country'), $slug, $this->limit); } else { $_GET['l'] = escape($city); $_GET['tl'] = 1; $this->listings_model->category_location_tag_search(false, $module, 'search', NULL, NULL, $this->limit); } } else { $_GET['l'] = escape($slug); $_GET['tl'] = 2; $this->listings_model->category_location_tag_search(false, $module, 'search', NULL, NULL, $this->limit); } } else { $this->listings_model->category_location_tag_search(false, 'listings', 'cities', $this->session->userdata('search_country'), $slug, $this->limit); } }
/** * Browse By Category and Location */public function browse($category, $state, $city = null) { $category = $this->db->get_where('categories', array('slug' => escape($category)))->row(); if($category) { $_GET['cg'] = $category->id; } if(!empty($state)) { $_GET['l'] = escape($state); $_GET['tl'] = 2; } if(!empty($city)) { $_GET['l'] = escape($city); $_GET['tl'] = 1; } $module = 'listings'; $this->listings_model->category_location_tag_search(false, $module, 'search', NULL, NULL, $this->limit);}
Add the below lines to the application/config/routes.php file after line number 269.
$route['category/(:any)/location/(:any)/(:any)'] = 'listings/browse/$1/$2/$3';$route['category/(:any)/location/(:any)'] = 'listings/browse/$1/$2';
Add the below lines to the public_html/.htaccess file after line number 192:
# DETAIL PAGE REDIRECT RewriteCond %{THE_REQUEST} ^[A-Z]{3,}\s/+([^&\s]+)\.html [NC]RewriteCond %{REQUEST_URI} !^/[0-9]+\..+\.cpaneldcv$RewriteCond %{REQUEST_URI} !^/[A-F0-9]{32}\.txt(?:\ Comodo\ DCV)?$RewriteRule ^ https://www.locallid.co.uk/detail/%1 [L,R=301,NE]