Sears-Magento Integration

To install the Sears extension:-

• Login to your Magento Admin Panel.
• Select System >> Magento Connect >> Magento Connect Manager.
• Magento Connect Manager login Panel Appears. Log in with your Admin Credentials.
• Unselect the "Put store on the maintenance mode while installing/upgrading/backup creation" option.
• In "Direct package file upload" section browse the Sears Extension package and click on upload.
• The Sears Extension gets uploaded to your Magento.

Once the merchant installs this extension:-

• Configuration settings will be created in his Magento admin panel’s System Configuration named as ‘Sears configuration’ under CedCommerce Extension tab.
• As well as a menu will be added to the menu section named as Sears that will consist of all the panel listing.
• This extension will also create a tab in the product’s general tab named as sears.com which will list all the created sears.com attribute.

If any merchant has created his account on sears.com and not enabled his API yet then he can enable his API panel from Sears > API.
It will open a page asking ‘Set up your test API’.

Enable product API

To enable the product API, the merchant needs to send SKU, price as well as inventory. So a setup has been prepared by sears > API. For this, the merchant only needs to click on Send button.Once your product information will be sent, button text will be changed to Send Successfully.

Enable order API

To enable order API on sears.com the merchant needs to create an order from Order Generator.For this a link has been given named as Order Generator, it will redirect the merchant to sears.com order generator.

Once the order has been created the merchant needs to click on the Send button next to Acknowledge Order to send Acknowledge Order.

To enable Cancel Order the merchant needs to click on the Send button next to Cancel Order.Once the order information will be uploaded successfully, the button text will be changed to Send Successfully.

Enable return API

Return API used to manage Returns generated for the completed order on sears.com.
To enable return API merchant needs to click on Send button next to Enable Return.
Once the return is complete, the button text will be changed to Send Successfully.

In order to obtain the live mode credentials, all the Test APIs should be run because Sears doesn’t provide Live Mode details until all the Test APIs have been set up.

To configure the settings in sears > configuration the merchant needs to login to his account.

• Click on API link to obtain the API key, Secret Key, and Merchant Id.
• Click on Fulfillment link to generate a Fulfillment Node as per Sears specifications to have a Sears Fulfillment Node Id.

The above details will be used in the sears > configuration settings in the merchant’s admin panel.

Before creating Sears Attributes it is necessary to create Sears Categories by uploading the CSV file.

If the Sears Categories are already created then:-

• From Magento, admin panel menu select Sears > Manage Sears Attributes.
• Click Import New Attribute button to automatically create all the attributes.
• After updating all the categories and attributes go to Catalog > Manage Products and select all the products.
• From the mass Action drop-down Select all the products, choose Update Attribute and click Submit button to update all the attributes and categories.
• The Update Attribute page will appear. Scroll down to locate Sears Product Status field.
• Tick the check-box next to "Change" so that all the products go to Not Uploaded state by default. Now click on Save Button.

After the categories get created in Magento, they need to be assigned to the products.

For this purpose:-

• From Magento, admin panel menu select Catalog > Manage Products > Select the product to be edited and locate the Categories tab.
• Now Select a category which has to be assigned to the product.

NOTE:- A product can be assigned to a single category only as this is the specification of Sears.com and we have to follow it.

For uploading the products on sears.com:

• Click Sears > Manage Products > Upload Product in the menu section to open Product Manager.
• Select the product whose status is Not Uploaded.
• Select Selected Product Upload option from the Mass Action drop-down and click Submit button.
• A message will appear in product upload panel reading “Your product has been successfully uploaded”.
• Click on "Get Updated Product status" to update the Sears Product Status immediately.

The Necessary Information regarding Product uploads are:-

• The Product must be assigned to a sears category. One product can be assigned to only one Sears category.
• A product must have one of the following information (UPC, UPC-E, GTIN-14, ISBN-13, ISBN-10, EAN, and ASIN).
• For uploading the configurable products, it is necessary that their associated product must be uploaded first.
• Initially, when the product will be uploaded, its default status will be ‘Not Uploaded’.
• When the product will be successfully uploaded its status will change to ‘Processing’.

To Archive/Close/Disable the product:-

If a merchant wants to close his uploaded product at any time after successful upload then it can be easily done. For this, the merchant needs to select the product from the product panel by selecting the check-box. After that, he needs to select the archive action and click on the Submit button. That product will be archived successfully and its status will change to Archived. This product will be closed on sears.com and it will not appear on sears.com for purchase.

To Unarchive /Reopen/Enable the product:-

Sears.com provides the ability to reopen closed products. For this, the merchant needs to select the archived product and then select the Un-archive option from the Action drop-down and click on the Submit button. The selected product will be available again for purchase on sears.com.

If the merchant wants he can archive or un-archive a single product also. To do this, the merchant needs to go to the View Detail action of the product from the product panel. If the product is open an Archive button will be shown. If the product is closed, the un-archive button will be shown. From here the merchant can choose a specified action as he wants.

Due to any reason if an error occurs during the product upload then that product will be listed in the Rejected File panel.

• Select Sears > Manage Products > Rejected Files from the menu section to open Rejected Sears Files, Manager.
• From here the merchant needs to go to View Error & Resubmit action.
• By Clicking on the "View Errors and Resubmit" link "Error Files Information" page appears.
• The error gets listed over here in the Error Description section.

Note:-

It is the responsibility of the admin to check details of all the uploaded products, rectify the error and then click on the Resubmit File button.

When an order is generated on sears.com, then the merchant should notify sears.com that whether he is able to fulfill the orders or not.

For this purpose:-

• Go to Sales > Orders. All the orders will be shown here.
• Click on the View button of the Pending order to open the Order View Page.
• Click Acknowledge button to acknowledge the order and click Reject button to reject the order.
• If Acknowledge button is clicked then the admin cannot reject it.
• If Reject button is clicked then it cannot be acknowledged and the Order Status will change to Cancelled.

As soon as the latest orders are fetched, a notification appears in the admin panel’s notification area and those orders get Auto-Acknowledged.This is done so that if the merchant is unable to acknowledge the orders within 2 hours then they don’t get rejected.

Note:-Whenever any one of the two buttons is clicked both of them get disabled after some time.

For shipment, we have added a tab ‘Ship by Sears‘ from which the merchant can create shipment for orders. This tab will be visible only if the order has been placed from Sears.com.

For this purpose:-

• Go to Sales > Orders. All the orders will be shown here.
• Click on the View button of the Pending order to open the Order View Page.
• Click Acknowledge button to acknowledge the order and click Reject button to reject the order.
• Click on Ship By Sears option for shipping purpose.
• Here the merchant needs to enter the tracking number, quantity ordered will be auto-filled.
• In the quantity canceled field, the merchant needs to enter the quantity he is not able to supply at the time of orders.
• Product sku will reflect the SKU of the ordered quantity.
• If the merchant wants to send a Return location address then it can be done by selecting ‘yes’ from the drop-down.
• It means if after order completion the customer generates a return request for this order then this product will be returned to the address set in the return location configuration.
• When the merchant clicks on the Ship button, the order will be shipped and its invoice and shipment will be created automatically in Magento.
• The status of the order will change to Completed.

List of failed orders can be viewed by:-

• Selecting Sears > Sears Orders >View Failed Import Sears Orders Log from the menu section.
• This section displays the failed orders with their order id and the reason for their failure.
• To manually fetch the latest orders (if required immediately) the merchant can click on the “Fetch Latest Orders” button.

These orders can be deleted from here by:-

• Select the orders to be deleted and then,
• Choose Delete option from the mass Action drop-down and click Submit button.

Note:-If orders are not properly Acknowledged(due to any reason) then sears itself rejects those orders.

Whenever a return will be generated for a completed order then it will be listed in the Return panel with status Created and the merchant (admin) will be notified about it by notification in the admin panel.

• Select Jet > Jet Orders > Return from the menu section to open the Return Management page.
• Click on the Edit link of any particular row in the grid that appears on Return Management page to open "Return Fields" form.
• Once the merchant fills all the fields and clicks on the Submit Return button, his return will be completed on sears.com.
• A message will appear in the pop up showing that his return has been completed and in the return panel its status will be changed to Completed.

To manage this type of return there is a panel ‘Sears Refund’:-

• Select Sears > Sears Orders > Refund from the menu section to open the Refund Management page.
• Click on "Get Updated Refund Status" button to get Updated Refund Status immediately.
• Click on Create New Refund button to open Refund Information form.
• This will open a form for entering the Refund related information.
  • Refund id This is the refund id that merchant will get from sears.com after the refund request has been created. The merchant doesn’t need to enter this at the time of refund creation.
  • Merchant Order Id This is the order id for which return request has been generated.
  • Order item id This is the item id that has been ordered.
  • Qty Returned This is the total quantity that has been returned. It should not be more than shipped quantity.
  • Qty Refunded This is the quantity that the merchant wants to refund. It should not be more than the returned quantity.
  • Refund tax This is the tax applied on the products returned .
  • Refund Amount This is the amount that sears have to return to the customer.
  • Shipping Cost This is the shipping cost applied to the returned product.
  • Shipping tax This is the shipping tax applied to the returned product.
  • Refund Feedback This is the feedback that the merchant wants to send the returned product.
  • Refund Reason This is the reason why the customer has returned the product.

And then click on "Submit Refund" button. A Success Message will be displayed after some time.

Click Sears > Configuration in the menu section to open Sears Configuration.

• Enabled: Set Yes To display the module at front-end.
• Enter API URL, API username (API User in Sears), API password (Secret in Sears)
• Enter Fulfillment Node Id and Email Id.
• In the Return Location, the merchant needs to enter the address where the product has to be returned if any return is generated for completed orders.

Note:- To enter API details:- Go to API from left navigation menu in Sears Partner Panel.To enter Fulfillment Node Id:- Go to Fulfillment > Fulfillment Node Id from left navigation menu in the Sears Partner Panel.These configurations are mandatory to set before integrating Magento store with sears.com This should be the first step after installing the extension on your site.

Whenever a product is uploaded then it gets uploaded in the form of batches of 30 products each. If 100 products are uploaded (say) then 4 batches will be formed with 3 batches having 30 products and the last batch having 10 products. For every batch, 3 files are created which are present at root in the var > sears upload folder. So, if total 4 batches are there, then 12 files will be created. These files are then compressed and uploaded on sears.com.

The 3 files include:-

1.inventory {timestap}.json, having details of the quantity of inventory of 30 products, according to the fulfillment node, which are mentioned in the SKU file

2.price {timestap}.json file, having the details of the price, according to fulfillment node, of those 30 products which are mentioned in the SKU file and

3.sku {timestap}.json file, having general details of those 30 products related to SKU, etc.

Whenever a product is not uploaded and some error is generated then it gets listed in the error files section which includes any one of the 3 files. The content of those files should be seen by the merchant to locate the product having the error so as to rectify those errors and resubmit the file.

After all the files are submitted to sears.com server, they then process those batch files. If all the information about the products is processed then the products are uploaded & moved to the Processing state otherwise the batch file is marked as "Processing with an error status.”

To map an already existing category to a Sears category, go to Catalog > Manage Categories. Select the required category that needs to be mapped (should be a non-Sears category) and click on the "Sears Category Mapping" tab, where you need to select the required category from the drop-down, then click on Save Category button. Now go to Catalog > Attributes > Manage Attributes > Edit the required attribute > Sears Attribute Tab. Enter the “Attribute Id” of the Sears Attribute that has to be mapped with the Magento Attribute in the Sears Attribute Id field. Now click on the Validate button. When you map your Magento category, all products of the mapped category get listed in Manage Product grid of Sears.

Brand signifies the name under which a product comes. The Brand attribute has been marked as important by Sears. Therefore, before uploading a product on Sears it should be checked that the product's brand name is provided to ensure that the product gets successfully uploaded on Sears.

After uploading the product, if no error files are generated still the product is not visible on Sears and no files are generated in the Sears Partner Panel > API > File Uploads section then that means the product has been successfully uploaded on Sears. If is it not getting listed then that is an issue of Sears as sometimes the products get stored in their backend but never get listed due to some internal issue of Sears. In this case, the Sears support Team should be contacted.

You cannot add discounts but you can use the Rules Engine which is available in the Sears partner panel and update pricing to become more competitive on products.

If the product is in the "Under Review" section of sears for a long time then it may be because all the details of the product might not have been entered. Although it takes approximately 1 week for the products to go from "Under Review" section to Live Mode. To speed up the process, all the sears attributes assigned to the product under Sears.com tab on product edit page should have proper values and none of the attributes should be left blank. This way sears will receive all the values for all the attributes. If Sears was looking for some attribute value which was causing the products to remain in "Under Review" section then by providing values for all the sears attributes this problem may not occur and the products will go to Live Mode if no other issue happens to be on Sears.

Sometimes the products get stored in their backend but never get listed on the frontend as this is Sears.com's internal issue which when gets resolved, the products start showing up at frontend.

Follow the path as mentioned below:

Sears >> Manage Product >> Upload Product

The Sears Product Status is empty because upon installation of Magento-Sears extension the Catalog Product attribute-Sears_Product_Status is created that reflects the latest product status as on sears.com.

Under Product Edit section the sears.com tab appears that further leads to Sears Product Status drop-down.
Select the "Not Uploaded" option from the Sears Product Status drop-down before uploading any product on sears.com.

Alternatively, you can apply the Mass Action drop-down option "Update Attributes" through Catalog >> Manage Product Grid

1) A select number of products which you wish to upload on sears.com.
2) Select the drop-down option "Update Attributes" and click on the Submit button.
3) Set Sears Product Status as "Not Uploaded".
4) Click on the Save button.

Tier price cannot be uploaded to Sears.com. But Sears Provided a Sears Rule Engine to apply customer benefit settings. These settings can be found on your Sears Partner Panel. You need to use Rules Engine (available in the left side menu in the partner panel) & contact to partner panel support for "How to use Sears Rules Engine. The module doesn't include these features as there is no API for this.

From Magento-Sears extension for uploading the variant product.

• If a merchant wants to upload a variant product say a shirt(S1) having size as an attribute(large, medium, small).
• So, he will create 3 variation products (S1-large), (S1-Medium), (S1-small).
• Now when he will upload this product on to sears the product which has been uploaded first will be the parent product and the remaining 2 products will be child product.
• So, if (S1-Medium) product is uploaded first on sears then this will be the parent product and (S1-large), (S1-small) product will be the child product of (S1-Medium).

Note- The Product S1 will not be uploaded to sears and only (S1-large), (S1-Medium), (S1-small) these products will be uploaded to the sears.