 |

Find Importers and Exporters of X Product?
TOPIC: PIERS Imports (U.S. Ports) (File 573) and PIERS Exports (U.S. Ports) (File 571) are compilations of manifests of vessels loading and discharging international cargo at more than 130 seaports of the United States and Puerto Rico, and approximately 11 key seaports in PIERS Imports (Latin America) (File 574) or PIERS Exports (Latin America) (File 572). Details on each individual shipment are stored in the databases.
Principal applications include: identification of trade opportunities, monitoring imports and/or exports of products whose details are lost in traditional government reports, and identification of potential trade partners. All waterborne international trade movements are captured: containerized, break bulk, dry bulk, and tanker. There is approximately a two-month lag between vessel arrivals and the loading of the data into the files. The PIERS databases are produced by Commonwealth Business Media, publisher of The Journal of Commerce.
The following search shows how to identify product codes, and then find the companies that imported the products in PIERS Imports (U.S. Ports).
Note: There are two pre-formatted reports available in PIERS: one in PIERS Exports (U.S. or Latin America) (Files 571,572) and one in PIERS Imports (U.S. or Latin America) (Files 573,574). These reports aggregate the shipments of each company retrieved by a search statement and rank the companies by the weight of their total shipments. The company with the greatest total cargo weight appears first. Pre-formatted reports allow analysis of shipping patterns and trends that influence the marketplace.
COMMAND SUMMARY
BEGIN 573
SELECT CELLULAR(1N)(TELEPHONE? OR PHONE?)/PS,PN
TYPE S1/6/1-10
EXPAND PC=6846000
SELECT E3 AND S1
SELECT S2 AND PD=20070701:20070930
DISPLAY SETS
REPORT S3/IMPORTER
Enter a title for the report
Enter Y or a number to display importers
HOW TO...

1. BEGIN File 573 to search PIERS Imports (U.S. Ports)
2. SELECT terms. Restrict to the Product Shipped (/PS) and the Product Named (/PN) fields. By using a comma, you are “OR”ing the two fields. Use truncation (?) to retrieve all forms of the root word, e.g. telephone or telephones. Note that the terms “telephone?” or “phone?” are “nested” so that Dialog will search for those terms first. The proximity connector (1N) specifies that “cellular” appears near “telephone?” OR “phone?” within one word, in either order. |

?B 573
File 573:Piers Imports(US Ports) 2007/Dec W2
(c) 2007 Commonwealth Bus. Media
Set Items Description
--- ----- -----------
?S CELLULAR(1N)(TELEPHONE? OR PHONE?)/PS,PN
2554 CELLULAR/PS,PN
33486 TELEPHONE?/PS,PN
18414 PHONE?/PS,PN
S1 1250 CELLULAR(1N)(TELEPHONE? OR PHONE?)/PS,PN |

3. TYPE the first several records in Format 6.
This format shows the date of shipment, the Product Shipped, the Product Name and the Product Code. Use the latter to identify a Product Code (PC=) for your search.
To select the appropriate record number, look at the range of records in the TYPE command (e.g., 1/6/2).
Note: Some records have been omitted from this display. |

?T S1/6/1-10
1/6/1
DIALOG(R)File 573: Piers Imports(US Ports)
(c) 2007 Commonwealth Bus. Media. All rights reserved.
0074906571
Product Imported: CELLULAR PHONE ACCESS
Product Code: 6846000 (TELEPHONE; INSTRUMENT,EQPT,SUPPLIES)
Date of Arrival (YY/MM/DD): 071117
1/6/2
DIALOG(R)File 573: Piers Imports(US Ports)
(c) 2007 Commonwealth Bus. Media. All rights reserved.
0074888873
Product Imported: CELLULAR PHONE
Product Code: 6846000 (TELEPHONE; INSTRUMENT,EQPT,SUPPLIES)
Date of Arrival (YY/MM/DD): 071118
1/6/3
DIALOG(R)File 573: Piers Imports(US Ports)
(c) 2007 Commonwealth Bus. Media. All rights reserved.
0074882312
Product Imported: CELLULAR PHONE CASE
Product Code: 6846000 (TELEPHONE; INSTRUMENT,EQPT,SUPPLIES)
Date of Arrival (YY/MM/DD): 071118 |

4. EXPAND the Product Code you have identified. Look for references pertaining to your product code number and related numbers in the index next to it.
5. SELECT the appropriate “E” Reference number(s); AND it with Set 1 (S1), your original search statement. This insures that you retrieve your desired product terms within this product code.
6. LIMIT your results to a specific date range. The colon indicates a range.
7. DISPLAY SETS (DS) to review your search strategy. |

?E PC=6846000
Ref Items Index-term E1 10580 PC=6845000 (APPLIANCES; NOS)
E2 10319 PC=6845050 (HAIR CURL & DRY DEVICE, FACE SAUNA)
E3 31067 *PC=6846000 (TELEPHONE; INSTRUMENT, EQPT,SUPPLIES)
E4 4354 PC=6846400 (COMMUNICATE EQPT,TELEGRAPH,TELETYPE)
E5 79883 PC=6847000 (AMPLIFICATION EQUIPMENT)
E6 44663 PC=6850000 (AUDIO EQPT; STEREO,RADIO,SCANNERS)
E7 96425 PC=6852000 (TELEVISION APPARATUS, VIDEO RECORD)
E8 1530 PC=6852045 (TUNERS; (ANY))
E9 3481 PC=6852050 (CONVERTERS; TELEVISION,RADIO)
E10 19568 PC=6853200 (PHONOGRAPH, TURNTABLES, JUKEBOX)
E11 1657 PC=6856000 (NAVIGATION EQPT;RADAR,SONAR,SOUNDER)
E12 10439 PC=6857070 (ALARMS, DETECTORS; SOUND,SMOKE,FIRE)
(...)
Enter P or PAGE for more
?S E3 AND S1
31067 PC=6846000(TELEPHONE; INSTRUMENT,EQPT,SUPPLIES)
1250 S1
S2 1061 PC='6846000' AND S1
?S S2 AND PD=20070701:20070930
1061 S2
2691027 PD=20070701 : PD=20070930
S3 111 S2 AND PD=20070701:20070930
?DS
Set Items Description
S1 1250 CELLULAR(1N)(TELEPHONE? OR PHONE?)/PS,PN
S2 1061 PC='6846000' AND S1
S3 111 S2 AND PD=20070701:20070930 |

8. Create a pre-formatted Importer Report with the REPORT command.
9. Enter an optional title for the report.
10. Enter Yes (Y) to accept all 48 importers, or specify how many companies’ shipment details you wish to see.
Note: charges for pre-formatted reports in the PIERS files are based on the number of shipments displayed. Each company could have several shipments. The minimum rate covers the first 100 shipments. Beyond that, there is a charge for each additional shipment.
So if, for example, the first company had more than 100 shipments, you would be charged accordingly. You can tell from your set results how many shipments are found in the search. For example, S3 had 111 results (or shipments) of the product.
You can also use the RANK command to check the number of shipments each company imported. The command in Files 573,574 is RANK IM. (In Files 571, 572 it is RANK CO). Enter HELP RATES 573 for pricing details for File 573.
Note: Part of this report is omitted from the display. |

?.REPORT S3/IMPORTER
Sorting 111 records
PIERS REPORT processing begins...
Processed 100 records
Enter title of up to 80 characters
?.IMPORTERS OF CELLULAR TELEPHONES
There are 48 importers (ranked by weight of shipments) in this report.
If you wish to view all of these importer listings, please press 'Y'.
If not, please enter the number of importers which you wish to view.
?y
DIALOG(R)File 573 :Piers Imports(US Ports)
(c) 2007 Commonwealth Bus. Media All rts. reserv.
IMPORTERS OF CELLULAR TELEPHONES
1. WIRELESS XCESSORIES GROUP, HUNTINGDN VLY, PA
Country Arrival Weight
Product Description of Origin Date (Pounds) Quantity
=====================================================================
CELLULAR PHONE ACCESS CHINA P 070715 547 48 CARTON
***Exporter: K MATE TELECOM ACCESSORIES, FANLING, HG KONG***
CELLULAR PHONE ACCESS CHINA P 070715 2431 105 CARTON
***Exporter: HCT INTL, HSI CHIH, CHINA T***
CELLULAR PHONE ACCESS CHINA P 070715 1884 157 CARTON
***Exporter: K MATE TELECOM ACCESSORIES, FANLING, HG KONG***
CELLULAR PHONE ACCESS CHINA P 070806 309 20 CARTON
***Exporter: K MATE TELECOM ACCESSORIES, FANLING, HG KONG***
CELLULAR PHONE ACCESS CHINA P 070904 13431 574 CARTON
***Exporter: TRENDY ELECTRONIC, NA, NA***
CELLULAR PHONE ACCESS CHINA P 070917 4684 250 CARTON
***Exporter: K MATE TELECOM ACCESSORIES, FANLING, HG KONG***
CELLULAR PHONE ACCESS CHINA P 070924 9211 658 CARTON . . . .
CELLULAR PHONE ACCESS HG KONG 070917 4256 329 CARTON
***Exporter: SUPER CAPTAIN, TAIPEI, CHINA T***
---------
>>>Total shipped 125,341. pounds
2. GOBILE INC, BROOKLYN, NY
Country Arrival Weight
Product Description of Origin Date (Pounds) Quantity
=====================================================================
CELLULAR PHONE CHINA P 070724 20123 1093 PIECES
***Exporter: GUANGZHOU LIAN GUANG ELECTRONIC, GUANGZHOU, CHINA P***
CELLULAR PHONE CHINA P 070913 17315 837 PIECES
***Exporter: GUANGZHOU LIAN GUANG ELECTRONIC, GUANGZHOU, CHINA P***
CELLULAR PHONE CHINA P 070930 20277 1071 PIECES
***Exporter: GUANGZHOU LIAN GUANG ELECTRONIC, GUANGZHOU, CHINA P***
---------
>>>Total shipped 57,715. pounds
3. TECHNOLOGY CONSERVATION, LECANTO, FL
Country Arrival Weight
Product Description of Origin Date (Pounds) Quantity
====================================================================
CELLULAR PHONES PTS BRAZIL 070908 41437 66 PACKS
***Exporter: SOLECTRON IND, CAMPINAS, BRAZIL***
---------
>>>Total shipped 41,437. pounds
(....) |
RELATED HOW DO I...? SOLUTIONS
NEED HELP?
Contact the Dialog Knowledge Center
Within North America +1 800 3 DIALOG (334 2564)
Outside North America 00 800 33 DIALOG (33 34 2564)
Web Form www.dialog.com/contacts/webform

|

You are viewing the

Click below to view the
 |