Press GeoDirectory Flat File Field

Required Plugins

  • wpperks plugin
  • Perks Flat File field Perks

Note

Few things you should keep in mind for the CSV file you want to import. 

  • DO NOT use the "newline" character in the description. It creates issues in the CSV import and then exports.
  • DO NOT use a comma in any cells, It is considered as a new separate column the words after the comma.
  • If you regenerate flat-file fields you need to add again field flat-file field on tabs
  • Basic Setup

    • Install & Activate wpperks 
    • Install flat file field wpperks and add the license key
    • Go to CPT settings - custom field - add flat file custom field

    • Settings Template Flat File
      • Go to wpperks - Flat Filed Field

    Add this Template according to the field that you will display

    /*Main Template*/
    <div class='gd-product-table-wrap' style='overflow-x: auto;'>
    	<table class='gd-product-table'>
    		<thead>
    			<tr>
           	  			<th>Product</th>
             			<th>Price Low</th>
            			<th>Price Fixed</th>
            		 	<th>Price High</th>
             			<th>Price Info</th>
        			</tr>
    		</thead>
    	</table>
    </div><br><tbody>{product_loop}</tbody>
    			
    /*Loop Template */
    <div class="gd-product-row">
    	<div class="gpr-left">
    		<div class="gpr-title">{Product}</div>
    		<div class="gpr-desc">{Description}</div>
     	</div>
       	<div class="gpr-right">{Price_Low}</div>
     	<div class="gpr-right pr-fixed">{Price_Fixed}</div>
      	<div class="gpr-right pr-high">{Price_High}</div>
    	<div class="gpr-right pr-info">{Price_Info}</div>
    </div>
    CSS Add on Detail Page
    <style>
    /*Perks Flat File*/
    table.gd-product-table {
    	margin-bottom: 0px;
    }
    .gd-product-row {
    	border-top: 0px;
    }
    </style>
    			

    How to Upload CSV

    Demo File CSV and Field Product Table https://docs.google.com/spreadsheets/d/1A8G4xORrTJI9Md-u5CXqnUDZUNON8-DlwfFZLV3BMOs/edit#gid=2112256385

    Single Import

    Single Import do not Requires an ID. Download single import demo CSV in the link above.

    On your single listing

    • Open your listing on backend or frontend

    • Go to your flat file field and upload your CSV and click Update Button

    • Check the detailed listing on the frontend, make sure the imported data appears like this

    Bulk Import 

    Bulk Import Requires an ID and the sheet should be sorted by ID. Download your bulk import demo CSV for 6 places or 6 products for each 6 places or in the link above. Make sure you change the post_id to match your listing id.

    For bulk import On your 6 places

    • Update the demo CSV sith your listing post_id
    • Go to Wpperks - Flat File - Bulk Import - fill in according to data
    • Choose your post type, field, and CSV File
    • Ready to Import
    • Check the detailed listing on the frontend, make sure the imported data appears like this

    For Bulk Import On your 6 products for each of the 6 places

    • Update the demo CSV sith your listing post_id
    • Go to Wpperks - Flat File - Bulk Import - fill in according to data
    • Choose your post type, field, and CSV File

    • Ready to import
    • Check the detailed listing on the frontend, make sure the imported data appears like this