Description:
The post and steps describe the process of Region Interface – Shipping to create the country, state, city, and area Pincode with the help of interface and base tables.
Interface Tables:
WSH_REGIONS_INTERFACE
WSH_REGIONS_TL_INTERFACE
Base Tables:
WSH_REGIONS
WSH_REGIONS_TL
Create Country:
Insert the following data into Interface tables
Generate Sequence_ID and use the same for both the INTERFACE tables.
Region_Type=0
Country and Country_Code should be NOT NULL.
Other values like state, city, parent_region_id, should be NULL.
Run ‘Region Interface’ import program to create COUNTRY records.
Create State:
Insert the following data into Interface tables
Generate Sequence_ID and use the same for both the INTERFACE tables.
Region_Type=1
Country, Country_Code, State, State_Code should be NOT NULL.
Parent_Region_ID should be the region_id of the corresponding COUNTRY record.
Other values like city, Postal_Code_From, Postal_Code_To should be NULL.
Run ‘Region Interface’ import program to create STATE records.
Create City:
Insert the following data into Interface tables
Generate Sequence_ID and use the same for both the INTERFACE tables.
Region_Type=2
Country, Country_Code, State, State_Code, City_City_Code should be NOT NULL.
Parent_Region_ID should be the region_id of the corresponding STATE record.
Other values like area, Postal_Code_From, Postal_Code_To should be NULL.
Run ‘Region Interface’ import program to create CITY records
Create Area/ Pincode:
Insert the following data into Interface tables
Generate Sequence_ID and use the same for both the INTERFACE tables.
Region_Type=3
Country , Country_Code, State, State_Code, City_City_Code, Area, Postal_Code_From, Postal_Code_To should be NOT NULL.
Run ‘Region Interface’ import program to create Area/ Pincode records.
Summary:
This Post explained what the steps should follow to create region interface – shipping
Queries?
Do drop a note by writing us at contact@staging.doyensys.com or use the comment section below to ask your questions.
