Add/Edit Your Coil Offerings

General

This page provides a coil supplier with a two options to add his Coil to the Multi-Supplier Inventory. The first option is to add coil offerings individually. This section also lets a supplier edit or delete individual offerings. The second option involves uploading an Excel file containing descriptions of your Coil offerings. Coil offerings in the uploaded file is added automatically. After Coil Offerings are added, new Offerings are sent to buyers who have signed up to Receive Coil Offerings by email.

Individual Coil Offerings

The form is used to add information describing your Coil Offering. The Type, Dimensions, Weight, Pieces, Description, Price, Tag No and Location fields are used to describe each of your Coil offerings. The Type, Dimensions, Weight and Location are required fields. Dimensions is in inches and can be specified as a decimal or fraction. Location is where the coil is physically located. The city and state abbreviation (or city and province abbreviation, if Canada) is separated by a comma. Units for the Price, unless otherwise identified, is US$ per CWT. Any information about your coil that is not specific to the other fields goes in the Description field.

Pre-Processing

We added a Pre-processing option that could be helpful to try to fill in some of the fields in the form. Copy the information describing your coil into the provided Pre-Process text box and press the "Pre-Process" button. The site will try to recognize the type, dimensions, location, price and weight from the description provided in the Pre-Process text box. Recognized fields will be placed in the appropriate fields and the remainder will be inserted in the Description field. Make any needed changes to the form and press the "Insert Coil" button to add your Coil to the Inventory. For example, the site is looking for a "$" or "CWT" to identify the price and "lbs" or "#" to identify the weight. It is looking for a number of terms separated by an "X" for the Dimensions. A number in parentheses is assumed to be the number of pieces. It also tries to find the location (City, State).

Multiple Coil Offerings

A coil supplier can also add, edit and remove coil offerings by uploading an Excel spreadsheet containing descriptions of his Coil offerings. Each offering is described on a single row. Steel Spider reads the file a row at a time and adds the offerings to our Inventory automatically. The location and order of columns containing the data about each offering determines how the file is processed. The supplier provides a file with the layout defined by the supplier. This supplier defined layout file is usually a file that the supplier is already preparing or is easily exported from the suppliers inventory database. It is usually an Excel file. Under certain circumstances we can handle a text file or an Adobe .pdf file.

Supplier Specified Column Layout Excel File (or Text File) - Automatic Data Entry Process

If you are considering using this Automatic Data Entry Process you need to Register first and then attach your coil inventory file to John@steelspider.com. We need to set-up the site to recognize the layout and other information about your file before you an use this. There is no charge to set this up and we provide a free trial period so you can evaluate using this method for adding your Coil Offerings to the Inventory.

The file format can be Excel but in some cases we can handle Text, Word or Adobe PDF. Send what you use internally. We will test the processing of the file on the site so we can recommend the simplest way to add your coil and walk you through the process. If your company uses codes or abbreviations, such as for location or grades, let us know what the codes represent and we can set up the site to recognize these and replace them with alternative terms that describe your coil. You can keep the codes in your file and will not need to convert them. This makes it possible for us to handle your inventory data without you having to do much "clean up" of the data. Using this method of providing your coil offerings also lets us do more to tailor how your offerings appear and provide more information than is available with the other methods. For example if your have pictures of your coil offering on your website, we can include a link to the applicable picture with the offering.

Scroll to the bottom of this page for Automatic Data Entry.

On this page you can add your Coil offerings to the Inventory along with the Coil of other suppliers so that buyers can search for needed Coil. You can also change or remove your Offerings in the Inventory here.

Buyers will receive an email notification of any new Coil offerings added to the Inventory if they have signed up to Receive Coil Offerings for Coil. In Receive Coil Offerings a buyer can specify which Coil Offerings he wants to be notified about by email by specifying type, dimension, weight or distance requirements.

We have provided two methods for adding your Coil Offerings to the searchable Inventory. The first is to add each coil Offering separately. The second involves uploading an Excel file to add multiple Coil Offerings automatically using a layout of your choosing. These methods are briefly described below and described in more detail in the Show Help for this Page link above.

You must login before you can use this page. If you have not already done so, Register with Steel Spider.

Add/Edit Your Individual Coil Offerings

To add an individual Coil Offering, form below needs to be filled in and saved. Required fields are outlined in red. If the form is not visible, Click on "+ Add Your Coil to the Multi-Supplier Inventory" below.

To simplify this we can Pre-Process the information about your coil and try to fill in some of the fields in the form. Copy the information describing your Coil Offering in the text box below and press "Pre-Process". Information that is recognized will be placed in the appropriate fields in the form below. Unrecognized information will be placed in Description. Review and make any necessary changes to the form before saving your coil offering by pressing the "Insert Coil" button. Hopefully you will find this simplifies entering your Coil data into the form.

Page size:

0 items in 1 pages

Row No

Delete

Edit


Type:	Aluminized Aluminum Castrip Cold Rolled Cold Rolled Embossed Cold Rolled Prepaint Cold Rolled Transitional Electro Galvanized Electro Galvanized Prepaint Electro Galvanized Transitional Electro Zinc-Iron Alloy Electrolytic Tin Plate Electrolytic Zinc-Nickel Electrolytic Zinc-Nickel Prepaint Enameling Steel Floor Plate Galfan Galvalume Galvalume Prepaint Galvanized Galvanized Bonderized Galvanized Prepaint Galvanized Transitional Galvanneal Galvanneal Bonderized Galvanneal Prepaint Galvanneal Transitional Hot Rolled Hot Rolled P&O Hot Rolled Pickled Dry Hot Rolled Prepaint Hot Rolled Transitional Long Terne Motor Lam Stainless Zam
Dimensions:
Weight:
Pieces:
Description:
Price $/cwt:
Location:
Tag No.:
:


:	Size Dimensions are in inches. Use decimal numbers or fractions. Separate terms with an X eg. 0.0170 N X 38.12 eg. 0.0196 X 47.32

Row No

Delete

Edit

Type

Dimensions

Weight

Pieces

Grade

Ctg. Wht.

Description

Price $/cwt

Location

Tag No.

Page size:

0 items in 1 pages

You have no Coil in the Inventory. To add Coil click on "+ Add Your Coil to the Multi-Supplier Coil Inventory"

You need to periodically update your Coil offerings to ensure that your Coil being advertised is still available. If you haven't returned to this page to check on your coil for 30 days we will email you a reminder to update your coil or confirm your coil's continued availability. If no confirmation is received, we will remove your coil.

Add/Change/Remove Multiple Coil Offerings - Automatic Data Entry

Some suppliers may find it easier and faster to automate the process of providing your coil offerings. To add your Coil Offerings you upload an Excel file with information describing each Coil on a single row. The uploaded file is processed and automatically added to the Inventory. The Layout of the uploaded file needs to be defined so the site knows where the appropriate information can be found. Our goal if for you to provide a file with a layout that is easiest for you to prepare. We tailor the automation process to handle your layout. A walk-through describing the options for handling Multiple Coil Offerings is provided in Show Help for this Page above. To add, edit or remove your Coil Offerings when you upload subsequent files we remove the Coil from a previous file and replace it with the coil in the current file.

Below is a listing of the files that have been setup to use with the Automatic Data Entry process.

When you upload your coil here, only the coil from your file will be displayed in the grid above so you can edit or delete individual items. A button will appear at the top right of the grid that will let you view and edit all your coil on the site if other methods were used to add Coil to the Inventory. Your file can contain both Coil and Sheet however only individual Coils can be edited above. Individual Sheet can be edited on Add Sheet.

Select the Description of the File that you will be providing.

Notes applicable to the selected file:

Expected File Layout:

Press Browse and select the file on your computer

Upload the file for processing.