Jump to content

nat8100

Members
  • Content count

    199
  • Joined

  • Last visited

Everything posted by nat8100

  1. Hi. I am trying to install manual order entry contrib: http://www.oscommerce.com/community/contributions,585/ The first step is to run this SQL file: # phpMyAdmin MySQL-Dump # version 2.2.6 # http://phpwizard.net/phpMyAdmin/ # http://www.phpmyadmin.net/ (download page) # # Generation Time: Feb 09, 2003 at 04:37 PM # Server version: 3.23.54 # PHP Version: 4.2.3 # -------------------------------------------------------- # # Table structure for table `spg_orders_shipping` # DROP TABLE IF EXISTS spg_orders_shipping; CREATE TABLE spg_orders_shipping ( orders_id int(6) NOT NULL default '0', orders_shipping_tracking_no varchar(40) NOT NULL default '', orders_shipping_date_shipped date NOT NULL default '0000-00-00', orders_shipping_carrier varchar(35) NOT NULL default '', orders_shipping_comment_internal text NOT NULL, orders_shipping_comment_customer text NOT NULL, orders_shipping_updated datetime NOT NULL default '0000-00-00 00:00:00', orders_shipping_status varchar(10) NOT NULL default '', orders_shipping_weight int(10) NOT NULL default '0', orders_shipping_act_cost decimal(10,2) NOT NULL default '0.00', orders_shipping_act_packing_cost decimal(10,2) NOT NULL default '0.00', order_type varchar(15) NOT NULL default '', auction_type varchar(15) NOT NULL default '', auction_no varchar(50) NOT NULL default '', auction_end_date date NOT NULL default '0000-00-00', payment_type varchar(15) NOT NULL default '', payment_ref varchar(25) NOT NULL default '', payment_date date NOT NULL default '0000-00-00', email_sent datetime NOT NULL default '0000-00-00 00:00:00', email_document_sent datetime NOT NULL default '0000-00-00 00:00:00', comments_clie longtext NOT NULL, comments_serv longtext NOT NULL, comment_pay longtext NOT NULL, comment_auction longtext NOT NULL, comments_inte longtext NOT NULL, creation_date datetime NOT NULL default '0000-00-00 00:00:00', margin_value decimal(8,2) NOT NULL default '0.00', margin_percent decimal(4,2) NOT NULL default '0.00', PRIMARY KEY (orders_id), UNIQUE KEY orders_id_2 (orders_id), KEY orders_id (orders_id), KEY orders_shipping_carrier (orders_shipping_carrier) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `spg_products_shipping` # DROP TABLE IF EXISTS spg_products_shipping; CREATE TABLE spg_products_shipping ( spg_products_id int(11) NOT NULL auto_increment, orders_id int(11) NOT NULL default '0', products_id int(11) default '0', qty_shp int(11) default '0', qty_cost decimal(8,2) NOT NULL default '0.00', products_quantity int(11) default NULL, products_price decimal(8,2) NOT NULL default '0.00', products_cost decimal(8,2) NOT NULL default '0.00', qty_back int(11) NOT NULL default '0', orders_products_id int(11) NOT NULL default '0', PRIMARY KEY (spg_products_id), KEY orders_id (orders_id), KEY products_id (products_id), KEY orders_products_id (orders_products_id) ) TYPE=MyISAM; # # Table structure for table `popup_help` # DROP TABLE IF EXISTS popup_help; CREATE TABLE popup_help ( help_id int(11) NOT NULL auto_increment, help_number int(11) NOT NULL default '0', help_class varchar(25) NOT NULL default '', help_module varchar(25) NOT NULL default '', help_file_name varchar(50) NOT NULL default '', help_title varchar(45) NOT NULL default '', help_text longtext NOT NULL, help_version varchar(12) NOT NULL default '', status tinyint(1) NOT NULL default '0', expires_date datetime NOT NULL default '0000-00-00 00:00:00', date_status_change datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY help_number (help_number), KEY help_id (help_id) ) TYPE=MyISAM; # # Dumping data for table `popup_help` # INSERT INTO popup_help (help_id, help_number, help_class, help_module, help_file_name, help_title, help_text, help_version, status, expires_date, date_status_change) VALUES (1001, 2, 'field_description', 'newsletter', '', '<b>Header/Footer Infos</b>', 'This screen allow you to add DYNAMIC headers and footers to your newsletters.\r\n<br>\r\nIn this configuration , the <b>Header </b>contains just "Dear" \r\n<br><br>\r\nIn the newsletter sent , we add the first name of the client just after the header before the body of the newsletter. \r\n<br>\r\nie Dear XXX.\r\n<br><br>\r\n<b>In the Unsubscribe Part 1</b> we add dynamically the link information + the email address of the user in order to link directly to an unsubscribe utility insterted at the bottom of the newsletter.\r\nThis unsubscribe utility link will direct the user to a page where he can choose to subscribe or unsubscribe from the newsletter.\r\n\r\n<br><br>\r\n<b>In the Unsubscribe Part 2</b> we end the unsubscribe text with whatever text you want to add to explain the process\r\n<br><br>\r\n<b>In the Footer field</b> we add the store informations and contacts. (or whatever you want to add: thank you note, special offer.....)\r\n\r\nit will come at the very bottom of the newsletter sent.\r\n<br><br>\r\n\r\n<b>MARKETING TIP</b>: it is good practice to add to every documents sent your contacts: email, phone , fax , web site adress.\r\n\r\nThis way a potential client or actual client does not have to search for your contact details . Everything is mentionned in all your communication.\r\n\r\n<br><br>', '1.0', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (2000, 2000, 'field_description', 'shipping', '', '<b>Payments: Fields explanation</b>', 'The info in the payment fields allow you to confirm the original payment method selected by the client or confirm a new method of payment.\r\n<br><br>\r\n<b>IMPORTANT NOTE</b>: We do NOT update the original order in order to keep a complete order trail . All infos in the shipping module are saved in the shipping module and do not alter the original orders. This way you can always review the original order.\r\nIt is important to rmember as someone not aware of the process may think there would be a discrepancy.\r\n<br>\r\nAll revised templates (invoice, packing list) accessible from the shipping module show all the info in the shipping module. \r\n<br><br>\r\nThe payments field allow you to entered more detailed information about the payment.\r\n<br>\r\nEspecially if payment is a check , Paypal, western union...\r\n<br><br>\r\n<b>Payment ref</b>: You can enter the reference number (transfer number, check number or any reference)\r\n<br><br>\r\n** You can add new payment methods by using "Payment Admin" link.', '', 1, '0000-00-00 00:00:00', '2002-12-14 09:10:25'), (2001, 2001, '1', 'field explanation', '', 'Sales & Auctions: fields explanation', 'The info in the order information fields allow you to select a sale Type and Sale Origin.\r\n<br><br>\r\nThis is particularly important to classify your sales if you use the manual entry utility to enter as well phone, mail orders and auctions sales.\r\n<br>\r\nIt allows you to have later reports and analyse your sales by Origin.\r\n<br><br>\r\n<b>Auction Number/ PO N?</b>: You can enter the auction number or a PO number if the client gave your one for this order. \r\n<br>\r\n<br>if you enter an auction number and select "Auction" as the Sale Type , a link will appear to direct you directly to the auction page.\r\n<br><br>\r\n<b>Order/Auction End Date</b>: You can enter the auction end date and keep track of the payment from your bidder. \r\n<br>\r\nIf the client sent you a purchase order you can enter that date.\r\n<br>\r\n<br>\r\n** for orders placed directly on the catalog, order date is already tracked.\r\n<br><br>\r\nVERY IMPORTANT: if you enter manually an auction , make sure to classifiy it as an auction. The email sent to the client is different : includes feedback info and other info about auction. all text can be modified in the admin screens.\r\n', '', 1, '0000-00-00 00:00:00', '2002-12-13 19:16:12'), (2002, 2002, '1', 'fields explanation', '', 'Comments: fields explanation', 'New Comments fields were added to the shipping module.\r\n\r\n<b>Order Comment</b> : you can only view comment sentered by client when placing order, you will not be able to modifiy it here.\r\n<br><br>\r\n<b>Shipping Comment</b> : Enter any information related to the shipping . this field can be seen by client on the account _history_info page. <br>\r\nDo NOT enter bad things about clients here.\r\n\r\n<br><br>\r\n<b>Billing Comment</b> : Enter any information related to the billing/payment method . this field can be seen by client on the account _history_info page. <br>\r\nDo NOT enter bad things about clients here.\r\n\r\n<br><br>\r\n<b>Internal Comment</b> : Any info you want to keep track of for that order without being seen by client. this field is not shown anywhere on the client side . \r\n\r\n', '', 1, '0000-00-00 00:00:00', '2002-12-13 19:20:46'), (2003, 2003, '1', 'fields explanation', '', 'Tracking process: fields explanation', 'You can record all infos abut the tracking in the fields\r\n<br><br>\r\n<b>Carrier Name</b> Select the carrier used to ship the package (this dynamic box can be administered via the "Shipper Admin" link if you need to add new carriers.\r\n\r\n<br><br>\r\n<b>Shipper Tracking Site</b> Once you select a carrier, a link will appear in order to track the package directly on their site (provided the tracking number exists and is valid)\r\n\r\n<br><br>\r\n<b>Shipping Weight</b> You can enter here actual weight (and not calculated weight from the shopping cart)\r\n<br><br>\r\nGives an idea of discrepancy between calculated weight and real weight . allowws you later to modify your shipping and handling handling fee to correct amount charged, or review weights entered for products is discrepancy is very important.\r\n\r\n\r\n\r\n', '', 1, '0000-00-00 00:00:00', '2002-12-13 19:26:41'), (2004, 2999, '1', 'Process', '', 'Shipping Module: Process Explanation', 'The shipping module brings new functionalities in the process of managing the orders and the logistic.\r\n<br><br>\r\n\r\n<b>Functionalities </b>\r\n<br><br>\r\nThis module does NOT modify in any way the original order data. All new info entered during the processing of an order \r\nis saved in new tables. \r\n<br>\r\nThis allow to keep a perfect audit trail.\r\n<br>\r\nThis module allows the following\r\n<br><br>\r\n\r\n<b> Admin side</b>\r\n\r\n<br><br>\r\nA. Manage Shipping Process of orders placed directly through oscommerce\r\n<br><br>\r\nB. Allows to enter MANUAL orders: Phone order or orders coming from other sources( fax, mail, auctions....) through secure ADMIN login.\r\n<br> \r\nThis modified login allows an administrator to create an account and enter manual order for the account of a client.\r\n(no emails are sent during the manual entry.)\r\nWhen all infos are entered, the admin can send an email to the client with all data info and login info to access his account.\r\n<br><br>\r\nC. Allows administrator to login with an ADMIN login under any client email (convenient for some of orders: Paypal is a good example \r\nwhere client would not press the return to catalog button on paypal site. the result is that the client paid Paypal but items stay in shopping\r\ncart instead of being proceesed as a confirmed order)\r\n<br><br>\r\nD. Payment Info : Administrator can enter payment ref, payment date, check number.....\r\n<br><br>\r\nE. Auction Info : if you place as well auctions on ebay or other, allows you to create an order in catalog and enter as well auction number auction end date....\r\ngives possiblity to send order status to person who won the auction: advantage is that you make the winner aware of your catalog\r\nYou ask him to login in the catalog part to see his auction status and tracking number. Thus he may come back directly to your site the next time.\r\n<br>\r\nAutomated direct link to auction page on major auction sites. you can add any auction site where you place auction through an admin page. \r\n<br><br>\r\nF. Tracking number Info: Entry of shipping date, tracking number, direct link to shipper site to track package.\r\n<br><br>\r\nG. Entry of qty shipped vs qty ordered. This allows to keep track of all back ordered items through a report and classify the order \r\nas "Partial Shipment" status. you can review the items and qunatities you still neded to ship.\r\n<br><br>\r\nH. Allows to send an email when package is sent with all infos above: in particular shipping date, carrier and direct link to track order on shipper site.\r\nemail date and time recorded and shown.\r\n \r\n<br><br>\r\nI. New templates of invoice and packing list with above information. \r\nCompany address, "Thank you Note" at bottom of printed invoice can be modified through admin. extra comment field for auctions can be managed through admin \r\nfor specific feedback or comments.\r\n<br><br>\r\nJ. All the validations tables records can be modified through admin interface screens. \r\n<br><br>\r\nK. Blacklist management: Added a blacklist field in customer table . Admin can block access to a client trying to login to his account.\r\n(interesting if fraud order was placed or chargeback. Client will not be able to order online again and message ask client to contact \r\ncompany to send money order for new order.) this solution allows to keep all information about all fraudulent orders or chargebacks or "bad customers". \r\n<br><br>\r\nL. 2 new comments fields were added : one for shipping, one for billing. both can be seen by client through the catalog side.\r\nA third comment field for shipping dept was added for private comments . not shown to client.\r\n<br><br>\r\nM. We added a way to manage the the header and footers of messages \r\nsent to clients during the shipping process (order shipped, Invoice Header and Footer)\r\nThis info can be edited directly through admin screens instead of going to the languages files and modify info.\r\n<br><br>\r\nNOTE: we created new validation tables for payment methods, shipping carriers specific to the shipping modules.... the tables are NOT linked to the actual shipping and payment modules.\r\nThe reason for that is the flexibility. Even though you would not accept for online orders a particular payment method (like western union Bidpay or Billpoint for example)\r\nyou can use it for manual entry of orders where you may accept this methods. This info is in fact very limited and the scripts fills the tables already with main payment or shipping infos. \r\n<br><br>\r\n\r\n<b> Catalog side</b>\r\n\r\n<br><br>\r\nA. Client can login to his account and see online all infos entered in the admin\r\n(Payment Info, Shipping Date, Tracking Number, auction info if auction.....)\r\n<br><br>\r\nB. Client can print the invoice or packing list template under order details.\r\n\r\n<br><br><br><br>\r\n<b>READ VERY CAREFULLY THE PROCESS BELOW BEFORE USING THE MODULE : SUGGESTED METHOD TO TEST THE MODULE after installation</b>\r\n<br><br>\r\n1. Create an order from the start after installing the module. ie start by creating an account (account info....)\r\n<br><br>\r\n2. Place an order for that test account.\r\n<br><br>\r\n3. We suggest to create 1 new order status: "Test module" or anything you want. it is always good to have a test account and a test order in the production application\r\nthis way you can always test new functionalities in this account and leave it separate from the other order statuses.\r\n<br><br>\r\n4. Once the account and order is created , you should see it in the pending orders as usual.\r\n<br><br>\r\n5. The shipping module process works this way (this is where you need to understand this work flow or you will be confused.)\r\n<br>\r\na. When you click on the shipping module in the left column you will see several options appearing\r\n<br><br>\r\n[Process]\r\n\r\n<br>\r\nOrders to Process<br>\r\nShipping Processing <br>\r\nManual Entry<br>\r\n<br><br>\r\n\r\nValidation tables (to be configured only once if needed and after you do not have to touch those again)\r\n<br>\r\nSupervisor Admin<br>\r\nShipper Admin<br>\r\nPayment Admin<br>\r\nSale Type Admin<br>\r\nSale Origin Admin<br>\r\nInvoice Admin<br>\r\nEmail Admin<br>\r\n<br><br>\r\n\r\n** All the validation tables are be very flexible in the maintenance, any admin user can add new shipping carrier and tracking link\r\nor new auction sites to keep track of auctions. As long as you know the basic info required in the validation table , it will be very easy \r\nto add your own info if needed. \r\n<br><br>\r\n\r\nb. The "Orders to Process" links gives you EXACTLY what you see now in the left column under Customers/orders\r\nWe placed the link again here for convenience only. it goes to the same page. (again you must see exactly the same thing as it is the same link)\r\n<br><br>\r\n\r\nc. The person in charge of processing the orders will go to the order page and will look as usual the orders to be processed. She will have a new column <br>\r\nwith the title [Process Shipping] or if she enters in the order detail she will see at the bottom a new button called [Process Shipping] as well.\r\nSame action on both sides. for convenience we include the link on the summary and order detail.\r\n<br>\r\nONCE she clicks on this link [Process Shipping] , a new record is created in the shipping database and ONLY at this moment the shipping tables are updated. THUS you will see\r\nunder Shipping Processing in the left column <b>ONLY</b> the orders where the Shipping [Process Shipping] was clicked. It means that someone started to work \r\non that order and we keep track of the starting date and time for reporting (average number of days between order creation and shipping: key indicator).\r\n\r\nNOTE: ** In a later release, the person processing the shipping will have to select an optional supervisor in charge of that order. this will allows quality control of the order (shipped ,quantities, backorder entry....)\r\n\r\n<br><br>\r\n\r\nOnce this button [Process Shipping] is clicked you can enter in the shipping module. you will see at the beginning the same info as in \r\nthe order page.\r\n<br>\r\nNew blocks were added for payment info, tracking and shipping info, auction tracking... + Qty shipped, shipping comments & billing comments\r\n<br>\r\nThis module will allow you to to enter all shipping info (each field has an online help by clicking on a popup window , thus we will not repeat that here.<br>\r\nThe use of the module is very simple and similar as you would do in other modules. \r\n<br><br>\r\n\r\n6. VERY IMPORTANT: TO SAVE YOU TIME : FOR THE FIRST TEST of sending emails to your test client and order, DO NOT CHANGE ANY VALUE in the validations table\r\n(invoice header, invoice footer, email header , email footer.)\r\n<br><br>\r\nMake sure everything works with the test data (send the email and print the NEW invoice & packing slip format. if you do not encounter any errors, it means that the module is intalled properly\r\nand you can start modifying the values in the validation tables to fit your needs.\r\n<br><br>\r\nAll is very straightforward in the validation screens. (popup help is as well present if in doubt) \r\n<br><br>\r\nThe module is very easy to use and staight forward. However it brings very important functionalities for all merchants shipping physical goods.\r\n<br><br> It allows you as well to kepp all infos in one systems which will save you a lot of time.<br>\r\nIt will give as well to the client a good level of information (online or by email) . \r\n<br><br>\r\nNOTE: If you do auctions on any auction site, it is a very good practice to enter all won auctions in the system . you can send great information to bid winner with all infos necessary. You give him as well the possiblity to know your site and be familiarised with your shipping management. it is likely that he may go directly to your site next time. \r\n<br><br>\r\nNothing prevents you to send all shipping and tracking info by email and include in the footer a special sale only available on your site. \r\nGreat for marketing\r\n\r\n<br><br>\r\nWill lower considerably the level of time spent on the phone answering questions like when was my order shipped ? what is the tracking number?\r\nthe client will be able to see all this info online or you can send hip through a flexible formatted email .\r\n \r\n<br><br>\r\nNOTES\r\n<br>\r\n\r\nPractice several times the use of sending emails (changing format and header or footer, signature in validation table to see where everythig is located in the final mail.)\r\n<br><br>\r\nAfter doing a few test orders, It will become very straight forward. \r\n<br><br>\r\nKeep good practices, always classify your order to the proper status, proper sales type & sales origin will help greatly the order management\r\n(those criterias will help you as well in the marketing and sales management: % of orders received online, by mail, auction.....)\r\n<br><br>\r\nMake sure you enter shipping date, check or money order number, tracking number, it is not only good for you when a client calls\r\nbut the client can directly loggin and see info and save you a lot of time in support.\r\n<br><br>\r\nSince you can modifiy easily through the admin the email sent to the client with the shipping info, make sure you include the fact that he can login at anytime to review status and tracking number. \r\n<br><br>\r\nClient will go online rather than calling you to ask you the same information. and since you sent him as well an email with all info when order shipped , you reduce greatly the support phone calls.\r\n\r\n\r\n\r\n\r\n\r\n', '', 1, '0000-00-00 00:00:00', '2002-12-14 11:07:33'), (2005, 6000, '1', 'Shipping', '', 'Manual Entry Process', '<b>Brief explanantion on secure key mechanism</b><br><br>\r\nIn essence, the login page was modified in order to create a temporary secure key instead of the password. This key is valid only for this session and is erased after. this key can only be generated from the admin side.\r\nThe secure key as well as the session \r\nid work in synch. (ie if one does not appear to be valid: mostly the case if some tries to call login admin page directly from the catalog side, you are not allowed the login , in fact you do not even see the info to login)\r\n<br><br>\r\n* Each new entry equals one secure key . we do not work with the session id as it can be recalled if link is bookmarked. here the secure key is generated at the beginning of the session and stored . at the end of the manual entry , it is erased. thus it can not be used again)\r\n<br><br>\r\nWe use a different login page in order to avoid any problems with future upgrades of core program)\r\n<br><br>\r\n<b>IMPORTANT POINT TO UNDERSTAND</b>: Once you are logged in with the secure key under the email of the client, you ARE the client in the system, you ARE in HIS account. Thus, do not place dummy orders or change anything than completing a manual order for him. \r\n<br><br>\r\n<b>BEFORE GOING LIVE</b> with actual clients accounts, we HIGHLY suggest that you create your own test account in the system and test everything in order to understand how process work. you do not want to place dummy orders under a client name or send him email confirming a test order you just did under his account.\r\n<br><br>\r\n\r\n<br><br>\r\nThe Manual entry process allows you to do 2 tasks.\r\n<br><br>\r\n-> <b>Client already registered</b> : you can login under his email address (you do not need to know his password)\r\n<br><br> you can review his shopping cart and finalise an order for him. \r\nWe use it mainly with Paypal orders. sometimes Paypal clients do not click back to return to catalog; even though payment is done in Paypal\r\n, items are still in the cart, thus you can complete for them .\r\n<br><br>\r\n(HOWEVER, you will need process the order as a check or money order payment, you can not reprocess it with a paypal payment as you do not know the client\'s card or paypal account info). this can be an issue if you do not offer a manual payment option (check, money order) as it does not appear in the payment options. the only awkward solution would be to turn on check payment during the time of the manual entry)\r\n<br><br>\r\nThe manual order entry is in fact the same as a normal entry. (uses same pages. You follow the same process and same pages as a normal order coming from the catalog. it is <b>only</b> on the <b>checkout_confirmation page</b> that you will see at the bottom of the page an "Admin Submit Button". To create the order PRESS this button and <b>NOT the normal confirm order button</b> in the middle of the page.\r\n(a normal session from the catalog will of course not see this button as it appears only when logging in under the admin and generating a secure key for the sesssion.)\r\n<br><br>\r\n-> <b>Client NOT registered</b> : Typically an order received by mail, phone, fax, auction..... you want to enter in the system in order for the client to be able to see the order status online.\r\n<br><br>\r\nIn that situation, you can create from the manual entry admin a new account for the client (for the password, you can either put his name , city, or just a random password and the client will have to use the "lost passowrd" utility in the catalog to receive a new password), \r\n<br><br>\r\nEnter the order as a normal order. if clien t wishes to pay with credit card, you can enter for him the card info he gave you if authorised by your credit card processor, or you select a manual payment method (check , money order) . You will be able to update the payment method later from the shipping module.\r\n<br><br>\r\n\r\nThis module is very simple as you use exactly the same screens as a normal order process. \r\n<br><br>\r\nThe <b>3 KEY POINTS</b> to remember are:\r\n<br><br>\r\n1. -> once you are logged in under the account of the client , make sure not to modify and info (address book). do not create dummy orders as they will appear under his account.\r\n<br><br>\r\n2. -> on the checkout_confirmation page, go at the bottom of the page, you will see an "admin submit button". do NOT press the confirm button.\r\n<br>\r\nthe admin button will not send an email to the client saying he just placed an order (he would not understand).\r\n<br>\r\nYou will be able to send an email with the order and tracking info from the shipping module.\r\n<br><br>\r\n3. -> Create a test account and practice several times before using it on a live client.\r\n<br><br>\r\n\r\n\r\n\r\n', '', 1, '0000-00-00 00:00:00', '2002-12-14 10:17:16'), (2006, 2006, '1', 'Shipping', '', 'Back Orders Items', 'You can modify quantities shipped here.<br><br>\r\n<br><br>\r\nIt is VERY IMPORTANT to classify the order as PARTIAL SHIPMENT if you have backordered items. We created reports and alerts based on that status in the shipping module.\r\n<br><br>\r\n1. go to Localization/Orders Status in admin to add this order status.\r\n<br><br>\r\n2. go to Shipping/ order Status in order to enter the id number for the order status\r\n<br>\r\nWe had to create this maintenance tool since some merchants may modify the order status in the core application of OSCommerce. it means that we could not define an id number as "partial shipment status" because some merchant may have deleted some status or renamed others, thus we would not be sure that a particular id number corresponds to the "partial shipment status". By confirming the id number of that status in our maintenance table we do not rely on the Localization/Orders Status but on the confirmed id in our module.\r\n<br><br>\r\n3. Once you classify an order as partial shipment, the report gives you all orders with back ordered items.\r\n<br><br>\r\nNOTE: The back order funtion is still very basic. ie there is no history per order of the changes in shipped quantities.\r\n<br><br>\r\nIn other words, you can do really 2 shippments while keeping an history (oringial partial shipment and shipment of backordered items in a second one)\r\n<br><br>\r\nBut in practice, it seems econically sensitive as you do not want to pay 3 times a shipping cost to ship an order (unless your client accepts to pay for it)', '', 1, '0000-00-00 00:00:00', '2002-12-14 11:40:04'), (2007, 2004, '1', 'shipping', '', 'Supervisor Admin Process', 'This module is in development.\r\n<br><br>\r\nNOT USED IN APPLICATION YET', '', 1, '0000-00-00 00:00:00', '2002-12-14 17:42:50'), (2008, 3000, 'Field Description', 'Shipping', '', 'Carrier Admin Process', 'This validation Table allows you to enter and maintain shipping carriers .\r\n<br>\r\n<br>\r\nIf you do not want to see a carrier in the drop down box, do not delete it , just turn the flag to inactive (red)\r\n<br><br>\r\nSince we entered Tracking URL form some carrier , you would have to reenter everything if you delte the record.\r\n', '', 1, '0000-00-00 00:00:00', '2002-12-14 17:45:53'), (2009, 4000, 'Field Explanation', 'Shipping', '', 'Payment Admin Process', 'This validation Table allows you to enter and maintain payment methods .\r\n<br>\r\n<br>\r\nIf you do not want to see a payment method in the drop down box, do not delete it , just turn the flag to inactive (red)\r\n<br><br>\r\n', '', 1, '0000-00-00 00:00:00', '2002-12-14 17:47:34'), (2010, 5000, 'Field Description', 'Shipping', '', 'Contact Admin Admin Page', 'In that screen, you can maintain the information shown in the headers and footers of the invoices (print templates both admin & catalog side).\r\n<br><br>\r\nThis module is not yet multilingual. \r\n<br><br>\r\nWill develop it in future version if needed .\r\n<br><br>\r\nTIP\r\n<br><br>\r\nyou can create several profiles if needed (useful for dropshipping)\r\n<br><br>\r\njust make sure only one profile for the invoice and one profile for the packing slip is set to active (green) at any one time.\r\n', '', 1, '0000-00-00 00:00:00', '2002-12-14 17:53:12'), (2011, 5002, 'Field Description', 'Shipping', '', 'Email Sent Admin Page', 'This allows you to modify header footer and signature file of emails sent to clients when order is shipped.\r\n<br><br>\r\nThis email will contain in the body<br><br>\r\n\r\nOrder status<br>\r\nShipping date<br>\r\nTracking number<br>\r\nCarrier<br>\r\ndirect Link to web site of carrier<br>\r\n<br>\r\n<br>\r\nYou can complete this default email by entering a header note , footer note, specific signature info.\r\n<br><br>\r\n\r\nWe decided to create this screen to be very flexible and not mix info with the invoice header.\r\n<br><br>\r\nYou may want to add info in the email but not on the invoice or packing slip.\r\n<br><br>\r\n\r\nClient will receive a well formatted email giving him clear infos about the shipping and the way to track his package. (provided of course your carrier uses a tracking number)\r\n<br><br>\r\n\r\nWill decrease considerably the support given to clients as they receive all tracking infos or can login to see it in their account.', '', 1, '0000-00-00 00:00:00', '2002-12-14 18:01:04'), (2012, 4001, 'Field description', 'Shipping', '', 'Order Status Admin', 'VERY IMPORTANT parameters\r\n<BR><BR>\r\nWe created this screen in order to match the order status from the core application with the shipping module.\r\n<BR>V\r\nThe reson is that order status in the core application can be created or deleted by the merchant and change the title.\r\n\r\n<BR><BR>\r\nThe shipping module ABSOLUTELY need to know the status code for:\r\n\r\n<BR><BR>\r\nPartial shipment<BR>\r\nProcessing<BR>\r\n<BR>\r\nMake sure to update the status id correctly before using the shipping module or you will get inconsistent results.', '', 1, '0000-00-00 00:00:00', '2002-12-14 18:05:26'), (2013, 30010, 'Process', 'Shipping', '', 'Suppliers', 'This admin screen allows you to maintain your supplier list.\r\n<br><br>\r\nOnce a supplier is entered, you can choose it from the drop down list when allocating a supplier to a product.', '', 1, '0000-00-00 00:00:00', '2003-01-20 08:04:46'), (2014, 30011, 'Process', 'Shipping', '', 'Supplier Products', 'This maintenance screen allows you to allocate a supplier for each product.\r\n<br><br>\r\nIt is mainly useful for the report <b>Items to Order</b>\r\n<br><br>\r\nyou will see on this report the list of products to order and the supplier.\r\n<br><br>\r\n', '', 1, '0000-00-00 00:00:00', '2003-01-20 08:11:02'); # -------------------------------------------------------- # # Table structure for table `spg_auction_type` # DROP TABLE IF EXISTS spg_auction_type; CREATE TABLE spg_auction_type ( auction_type_id int(11) NOT NULL auto_increment, products_id int(11) NOT NULL default '0', auction_type_date_added datetime default NULL, auction_type_last_modified datetime default NULL, auction_type_name varchar(35) default NULL, auction_type_title varchar(35) default NULL, auction_type_class int(1) NOT NULL default '0', auction_type_url varchar(100) NOT NULL default '', auction_type_url_tracking varchar(100) NOT NULL default '', auction_user_id varchar(40) NOT NULL default '', status int(1) default '1', auction_type_comments longtext NOT NULL, expires_date datetime NOT NULL default '0000-00-00 00:00:00', date_status_change datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (auction_type_id), KEY products_id (products_id) ) TYPE=MyISAM; # # Dumping data for table `spg_auction_type` # INSERT INTO spg_auction_type (auction_type_id, products_id, auction_type_date_added, auction_type_last_modified, auction_type_name, auction_type_title, auction_type_class, auction_type_url, auction_type_url_tracking, auction_user_id, status, auction_type_comments, expires_date, date_status_change) VALUES (1, 0, '2002-12-09 14:54:57', '2002-12-14 19:51:43', 'eBay', '', 1, 'http://www.ebay.com', 'http://cgi2.ebay.com/aw-cgi/eBayISAPI.dll?LeaveFeedbackShow&useridto=', 'palmsandgardens', 1, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (2, 0, '2002-12-09 14:55:13', '2002-12-14 19:51:51', 'Amazon', '', 1, '', '', '', 1, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (3, 0, '2002-12-09 14:58:20', '2002-12-13 13:45:06', 'Sale Site', '', 1, '', '', '', 1, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (4, 0, '2002-12-13 13:45:28', '2002-12-13 13:46:15', 'Sale Phone/Fax', '', 1, '', '', '', 1, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (5, 0, '2002-12-13 13:45:53', NULL, 'Sale Mail', '', 1, '', '', '', 1, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'); # -------------------------------------------------------- # # Table structure for table `spg_authorise` # DROP TABLE IF EXISTS spg_authorise; CREATE TABLE spg_authorise ( authorise_id int(11) NOT NULL auto_increment, products_id int(11) NOT NULL default '0', authorise_date_added datetime default NULL, authorise_last_modified datetime default NULL, authorise_name varchar(35) default NULL, authorise_title varchar(35) default NULL, status int(1) default '1', authorise_comments longtext NOT NULL, expires_date datetime NOT NULL default '0000-00-00 00:00:00', date_status_change datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (authorise_id) ) TYPE=MyISAM; # # Dumping data for table `spg_authorise` # INSERT INTO spg_authorise (authorise_id, products_id, authorise_date_added, authorise_last_modified, authorise_name, authorise_title, status, authorise_comments, expires_date, date_status_change) VALUES (1, 0, '2002-12-03 23:34:56', '2002-12-13 14:06:20', 'John Steed', 'Shipping Dept', 1, 'Person responsible for Quality Control of this order until shipment', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (2, 0, '2002-12-13 14:03:09', '2002-12-13 14:06:40', 'Emma Peel', 'Shipping Supervisor', 1, 'Person responsible for Quality Control of this order until shipment', '0000-00-00 00:00:00', '0000-00-00 00:00:00'); # -------------------------------------------------------- # # Table structure for table `spg_carriers` # DROP TABLE IF EXISTS spg_carriers; CREATE TABLE spg_carriers ( carriers_id int(11) NOT NULL auto_increment, carriers_phone varchar(25) NOT NULL default '0', carriers_date_added datetime default NULL, carriers_last_modified datetime default NULL, carriers_name varchar(35) default NULL, carriers_name_osc varchar(25) NOT NULL default '', carriers_url varchar(100) default NULL, carriers_track_url varchar(100) NOT NULL default '', status int(1) default '1', carriers_comments longtext NOT NULL, expires_date datetime NOT NULL default '0000-00-00 00:00:00', date_status_change datetime NOT NULL default '0000-00-00 00:00:00', products_id int(11) NOT NULL default '0', PRIMARY KEY (carriers_id), KEY products_id (products_id) ) TYPE=MyISAM; # # Dumping data for table `spg_carriers` # INSERT INTO spg_carriers (carriers_id, carriers_phone, carriers_date_added, carriers_last_modified, carriers_name, carriers_name_osc, carriers_url, carriers_track_url, status, carriers_comments, expires_date, date_status_change, products_id) VALUES (1, '1-800-5468', '2002-12-04 00:12:53', '2003-01-02 19:07:59', 'UPS', 'United Parcel Service', 'http://www.ups.com', 'http://wwwapps.ups.com/etracking/tracking.cgi?TypeOfInquiryNumber=T&track=Track&InquiryNumber1', 1, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0), (2, '1-800', '2002-12-04 00:22:17', '2003-01-02 19:07:41', 'USPS', 'United States Postal Serv', 'http://www.usps.com', 'http://trkcnfrm1.smi.usps.com/netdata-cgi/db2www/cbd_243.d2w/output?CAMEFROM=OK&strOrigTrackNum', 1, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0), (3, '1-800-fedex', '2002-12-04 16:02:17', '2002-12-04 16:02:17', 'FEDEX', '', 'http://www.fedex.com', 'http://www.fedex.com/cgi-bin/tracking?action=track&language=english&cntry_code=us&initial=x&tracknum', 1, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0); # -------------------------------------------------------- # # Table structure for table `spg_contacts_email` # DROP TABLE IF EXISTS spg_contacts_email; CREATE TABLE spg_contacts_email ( contact_email_id int(11) NOT NULL auto_increment, products_id int(11) NOT NULL default '0', contact_email_date_added datetime default NULL, contact_email_last_modified datetime default NULL, contact_info_name varchar(35) default NULL, contact_info_title varchar(35) default NULL, contact_info_value varchar(45) NOT NULL default '', email_subject varchar(65) NOT NULL default '0', status_update longtext NOT NULL, auction_merchant varchar(65) NOT NULL default '', auction_subject varchar(65) NOT NULL default '', history_info varchar(100) NOT NULL default '', auction_access longtext NOT NULL, status_auc_update longtext NOT NULL, auction_note longtext NOT NULL, status int(1) default '1', signature longtext NOT NULL, expires_date datetime NOT NULL default '0000-00-00 00:00:00', date_status_change datetime NOT NULL default '0000-00-00 00:00:00', sales_note longtext NOT NULL, PRIMARY KEY (contact_email_id) ) TYPE=MyISAM; # # Dumping data for table `spg_contacts_email` # INSERT INTO spg_contacts_email (contact_email_id, products_id, contact_email_date_added, contact_email_last_modified, contact_info_name, contact_info_title, contact_info_value, email_subject, status_update, auction_merchant, auction_subject, history_info, auction_access, status_auc_update, auction_note, status, signature, expires_date, date_status_change, sales_note) VALUES (1, 0, '2002-12-04 23:09:13', '2003-01-18 09:48:40', 'Email Sent Variables', 'Email Sent Variables', '2', '[Your Order Palms & Gardens: Shipping Update Order N?:', 'Thank you again for your order. \r\n\r\nYour order has been updated to the following status. \r\n\r\nPlease reply to this email if you have any questions. Please mention the Order Number', '', '[Palms & Gardens: Shipping Update Auction', 'http://www.palmsandgardens.org/catalog/account_history_info.php?', 'Thank you again for your auction. \r\n\r\nYour order has been updated to the following status. \r\n\r\nPlease reply to this email if you have any questions. Please mention the Order Number or the auction number and auction site.', '', '** You may track the shipping status of your auction by following the link above. In order to Login to see the PLANNED Shipping Date and the tracking number, \r\n\r\nYour email address is the login name and the password is your zip code. \r\n\r\n\r\nOur Online Auction Tracking application allows us to monitor more accurately all auctions won by bidders. We give them an up to the minute status on the planned shipping date after we receive their payment.\r\nAn email is sent to the winners every time we update the shipping status of their bids or they can login to our site to review it online.\r\nLet us know if you have any comments or feedbacks.\r\n\r\n(You may change your password after you login to your account\r\n\r\n** Important Note: we enter a PLANNED Shipping Date and the carrier tracking number as soon as your bid status is changed to Processing. \r\n\r\nHowever, the planned shipping date may only be in 2 or 3 days and the tracking n? will not be yet available in the carrier tracking system. \r\n\r\nIt is only when the status is changed to Shipped that the tracking number will be reflected in the carrier tracking system.\r\n\r\n\r\nAuction Feedback\r\n\r\nWe just wanted to thank you again for your bid and to inform you that we have left you positive feedback for your purchase.\r\n\r\nWe hope that you have had a positive purchasing experience. If so, we would greatly appreciate if you could leave us positive feedback.\r\nWe also hope that you will consider our plants again in the future.\r\n\r\nCustomer Service', 1, 'Thank you again for choosing Palms & Gardens for\r\nyour palms.\r\n\r\nRegards\r\n________________________________________\r\nPalms & Gardens Nursery Inc\r\n123 N Congress Ave #305qq\r\nBoynton Beach FL 33426 - USA\r\nPhone: 561-852-1789\r\nemail: sales@palmsandgardens.org\r\nWeb: http://www.palmsandgardens.org', '0000-00-00 00:00:00', '0000-00-00 00:00:00', ''); # -------------------------------------------------------- # # Table structure for table `spg_contacts_info` # DROP TABLE IF EXISTS spg_contacts_info; CREATE TABLE spg_contacts_info ( contact_info_id int(11) NOT NULL auto_increment, products_id int(11) NOT NULL default '0', contact_info_date_added datetime default NULL, contact_info_last_modified datetime default NULL, contact_info_name varchar(35) default NULL, contact_info_title varchar(35) default NULL, contact_info_value varchar(45) NOT NULL default '', company_name varchar(45) NOT NULL default '0', company_address varchar(50) NOT NULL default '', company_city varchar(40) NOT NULL default '', company_zip varchar(15) NOT NULL default '', company_state varchar(15) NOT NULL default '', company_phone varchar(25) NOT NULL default '', company_fax varchar(25) default NULL, company_url varchar(80) NOT NULL default '', company_email varchar(35) NOT NULL default '', company_doc_title varchar(25) NOT NULL default '', status int(1) default '1', thank_note longtext NOT NULL, special_note longtext NOT NULL, expires_date datetime NOT NULL default '0000-00-00 00:00:00', date_status_change datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (contact_info_id) ) TYPE=MyISAM; # # Dumping data for table `spg_contacts_info` # INSERT INTO spg_contacts_info (contact_info_id, products_id, contact_info_date_added, contact_info_last_modified, contact_info_name, contact_info_title, contact_info_value, company_name, company_address, company_city, company_zip, company_state, company_phone, company_fax, company_url, company_email, company_doc_title, status, thank_note, special_note, expires_date, date_status_change) VALUES (1, 0, '2002-12-04 18:02:06', '2002-12-14 17:32:05', '', 'Invoice Contact Infos', '', 'Palms & Gardens Nursery Inc.', '123 N. Congress ave #305', 'Boynton Beach', '33426', 'FL', 'Phone: (561) 852-1789', NULL, 'http://www.palmsandgardens.org', 'email@palmsandgardens.org', 'INVOICE', 1, 'If you have any questions or comments about your purchase, please don\'t hesitate to contact us at service@palmsandgardens.org. \r\n\r\nWe will get back to you within 24 hours. Please refer to the invoice number if you need to write or phone us about this order.', 'Thank you again for your order to palmsandgardens.org. \r\n\r\nWe strive to ship quality plants.\r\n\r\nVisit regularly our online catalog for Special Offers : http://www.palmsandgardens.org', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (2, 0, '2002-12-14 17:16:18', '2002-12-14 17:18:45', '', 'Packing List Contact Infos', '', 'Palms & Gardens Nursery Inc.', '123 N. Congress Ave # 305', 'Boynton Beach', '33426', 'FL', '(561) 852-1789', NULL, 'http://www.palmsandgardens.org', 'service@palmsandgardens.org', 'PACKING LIST', 1, 'This order was sent to you by:', 'We strive to ship quality plants.\r\n\r\nVisit regularly our online catalog for Special Offers : http://www.palmsandgardens.org', '0000-00-00 00:00:00', '0000-00-00 00:00:00'); # -------------------------------------------------------- # # Table structure for table `spg_man_info` # DROP TABLE IF EXISTS spg_man_info; CREATE TABLE spg_man_info ( spg_man_info_id int(11) NOT NULL auto_increment, spg_man_name varchar(25) NOT NULL default '', status int(1) NOT NULL default '0', manual_date_added datetime NOT NULL default '0000-00-00 00:00:00', manual_last_modified datetime NOT NULL default '0000-00-00 00:00:00', date_status_change datetime NOT NULL default '0000-00-00 00:00:00', expires_date datetime NOT NULL default '0000-00-00 00:00:00', spg_man_key varchar(24) NOT NULL default '0', spg_defined varchar(10) NOT NULL default '', spg_man_key2 varchar(24) NOT NULL default '0', spg_man_key3 varchar(35) NOT NULL default '', PRIMARY KEY (spg_man_info_id) ) TYPE=MyISAM; # # Dumping data for table `spg_man_info` # INSERT INTO spg_man_info (spg_man_info_id, spg_man_name, status, manual_date_added, manual_last_modified, date_status_change, expires_date, spg_man_key, spg_defined, spg_man_key2, spg_man_key3) VALUES (1, 'Manual Entry', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2003-02-09 16:25:01', '0000-00-00 00:00:00', 'dPS3PjX7hDWqIRorC97fsR4G', 'admin_log', '', ''); # -------------------------------------------------------- # # Table structure for table `spg_order_status` # DROP TABLE IF EXISTS spg_order_status; CREATE TABLE spg_order_status ( order_status_id int(11) NOT NULL auto_increment, products_id int(11) NOT NULL default '0', order_status_date_added datetime default NULL, order_status_last_modified datetime default NULL, order_status_name varchar(35) default NULL, order_status_title varchar(35) default NULL, order_status_class int(1) NOT NULL default '0', order_type_url varchar(100) NOT NULL default '', status int(1) default '1', comments longtext NOT NULL, expires_date datetime NOT NULL default '0000-00-00 00:00:00', date_status_change datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (order_status_id) ) TYPE=MyISAM; # # Dumping data for table `spg_order_status` # INSERT INTO spg_order_status (order_status_id, products_id, order_status_date_added, order_status_last_modified, order_status_name, order_status_title, order_status_class, order_type_url, status, comments, expires_date, date_status_change) VALUES (1, 0, '2002-12-14 12:12:21', '2002-12-14 12:47:27', 'Processing', '', 2, '', 1, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  2. nat8100

    [Contribution] STS v4

    Also.. here are the lines of code from my sts_inc/product_info if (tep_not_null($product_info['products_image'])) { $template_pinfo['imagesmall'] = tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"'); $template_pinfo['imagelarge'] = tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), '','',''); $template_pinfo['product_popup']= '<script language="javascript"><!--'."\n". 'document.write(\'<a href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . (int)$products_id) . '\\\')">' . $template_pinfo['imagesmall'] . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>\');'."\n". '//--></script>'."\n". '<noscript>'."\n". '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">'.$template_pinfo['imagesmall'] . '<br>' . TEXT_CLICK_TO_ENLARGE .'</a>'."\n". '</noscript>'."\n"; } else { $template_pinfo['imagesmall'] =''; $template_pinfo['imagelarge'] =''; $template_pinfo['product_popup']=''; } Can't see anything wrong myself?
  3. nat8100

    [Contribution] STS v4

    Hi.. please feel free to ask obvious questions - it is usually a silly mistake. However it is not that the image is too small... or the browser. I have image magic installed but have switched off at the mast switch and still no luck. I have tried changing different options in images etc. i.e calculate images to true and false but all the same. It is defintely taking the image size from the 'product information image width' in admin because if I change this the image changes accordingly. Are there any other settings in admin that could be affecting it? I have checked the properties.. by right clicking on the image etc. and it is referencing the right image, and has the width=180 in there. Had a look at my template.. can't find anything but may have missed something? Thanks
  4. nat8100

    [Contribution] STS v4

    Hi Bill, Thanks for your replies. Re. the content templates... I had the other templates working but just wasn't sure how or if you could create content templates based on a category.. but I think I've got a better idea now so will have a play and see if I can get it to work. Thanks. Re. the thumbnails I had a look however that doesn't slove my problem. I currently have the image sizing set up so that the image is width 180 and length 0 and have been using the popup image tag in my content template. However I thought the $imagelarge tag would show the image full-sized however when I use it in a content template it still shows the thumbnail size with a width of 180. Also.. another quick question.. is there a tag for the content template to show the manufacturer name or logo? I thought there would have been but can't find it in the list in the documentation. Thanks, Natalie
  5. nat8100

    [Contribution] STS v4

    Hi, I have 2 questions 1. I am having trouble with the imagelarge tag - it is just showing the thumbnail size. Has anyone else had this problem? 2. Is there any way I can create a product content template for a particular category? Any help greatly appreciated. Thanks
  6. nat8100

    Manual Order Entry Contrib

    it seems some of my post got cut... basically the error I get when I run the file in php my admin is: MySQL said: #1136 - Column count doesn't match value count at row 1 Has anyone had this error? what does it mean? how do I fix it? Thanks
  7. nat8100

    [Contribution] STS v4

    Hi, has anyone used this contrib: http://www.oscommerce.com/community/contributions,4549/ with STS product content templates? or does anyone know whether it will work?
  8. nat8100

    [Contribution] STS v4

    Thanks Bill.. I think i might just continue to use master products for my attributes for now but will ask in that forum as well. Thanks again.
  9. nat8100

    [Contribution] STS v4

    any pointers in the right direction? thanks
  10. nat8100

    [Contribution] STS v4

    Hi everyone. I've searched around and found similar problems but none of the solutions seem to help... not even sure if this is an STS problem or not... I am using the product info templates. I am also usign master products for some of these. I have just tried to create a product that uses the standard options/product attributes drop down list. The list appears fine... if I don't have the products quantity there the product won't add at all.. and if I do, the product will add but without the options.. any ideas how to get it to add to cart with the product attributes? Thanks
  11. Sorry, please ignore the above post.. have just downloaded the new version so that'll probably solve my problems! Thank you!
  12. Hi everyone... I have an error which I have read other people have had.. but can't find a solution that works for me.. but perhaps I'm missign something. when i go to www.domainname.com/googlesitemap/index.php i get all the right messages.. Generated Google Product Sitemap Successfully Generated Google Category Sitemap Successfully Generated Google Sitemap Index Successfully CONGRATULATIONS! All files generated successfully. etc. When I go to www.domainname.com/sitemapindex.xml i get: The XML page cannot be displayed Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later. -------------------------------------------------------------------------------- XML document must have a top level element. Error processing resource 'http://www.domainname.com/sitemapindex.xml'. Earlier in this forum someone said you can try and change soem code in includes/boxes/categories but my code seems to be somewhat different so can't find which bit to change. Coudl this be the problem? I tried uploading to google.. error: Sitemap Errors Empty Sitemap Your Sitemap does not contain any URLs. Please validate and resubmit your Sitemap. Any ideas? Thank you!
  13. nat8100

    Article Manager v1.0

    I had that error on my articles.php page and changed the query to: select a.articles_id from (articles a, articles_to_topics a2t) left join topics_description td on a2t.topics_id = td.topics_id left join authors au on a.authors_id = au.authors_id, articles_description ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY) seems to work for some and not others - so give it a go but back up!
  14. nat8100

    Google Analytics module

    Thanks for the quick reply!
  15. nat8100

    Google Analytics module

    Hi all.. I started using google analytics a few days ago. I didn't use this contrib.. I'm using STS and just inserted the code as directed by google before the /body tag in my templates.. and it worked fine.. apart from the security pop up bar on explorer for secured pages. So I guess this is the problem that this contrib overcomes? Or is it designed for more than that? Why do you put the code in the head tag when google says body tag? has anyone used with STS 4? Thanks!
  16. nat8100

    [CONTRIBUTION] CCGV (trad)

    Ok..well I've been messing about with the nochex files.. they are based on paypal IPN and use different files for checkout i think so tried adding ccgv to the additional files but still no luck.. think maybe the problem is to do with my SSL and not nochex, but can't think what as everything else seems to be working ok with the SSL and sessions. My balance shows in shopping cart but not in the checkout pages - if I put in a code and click redeem the page just refreshes and has the URL https://sslrelay.com/domainname.com/checkou...ft+Voucher+Code or (for a valid code) https://sslrelay.com/domainname.com/checkou...deemed+%A310.00 which all looks correct to me? but no message/s shown on the screen I really want to get my site live so I might just partially uninstall CCGV and sort it out when the site is actually making some money! Thanks for your help. and I'm glad it was just not me having problems accessing the forums - thought it was my computer or connection!
  17. Has anyone used CCGV with Nochex APC?
  18. nat8100

    [CONTRIBUTION] CCGV (trad)

    Hiya.. thanks for the reply. I'm using CCGV (trad)... I'm pretty sure I added all the code to checkout pages correctly.. it all seemed to be working before Nochex.
  19. nat8100

    [CONTRIBUTION] CCGV (trad)

    Has anyone used this contrib with Nochex APC? I can't redeem any vouchers or discount coupons at checkout. I can send to people and I can load the balance into my account and see it in my shopping cart.. but balance doesn't appear at checkout.. if I put in the code and click 'redeem' the page either does nothing or goes to the next page (checkout confirmation). Any suggestions of where to start looking for the problem?
  20. got the cart emptying now - solution on post 80. Seems to be working ok now.. I think the first transaction went wrong because I used a gift voucher as part payment so will look into that. Thanks for your help. :)
  21. Well I tried another transaction as a 'new user' and this time it went through to the checkout_success... however the the shopping cart didn't empty. The session ID is still visible in the URL, I'm still logged in and can navigate to my account and see the order I've just placed. Could it be something to do with my SSL settings?
  22. Thanks for your reply. My search engine friendly URLs are set to false but I am using SEO URLs contrib.. haven't had any trouble with it so far but will try turning it off and see if the same happens. Force cookie usage is false. The page did return to an empty cart (the shopping_cart page with nothing in it) the transaction went through.. the order got returned etc. There must be somewhere in nochex where you set the page it returns to? As you can do with paypal. What is the 'APC Responder Module Address'?
  23. Thanks! It works.. formatting a bit odd Firstname ,Lastname not sure where the comma is coming from but good enough for me! Thank you! :) now just to solve the redirection to checkout success page - any ideas on that one?
  24. nat8100

    [CONTRIBUTION] CCGV (trad)

    I sent a gift voucher to myself from admin. Then a made an order and redeemed it, which worked fine. However now the gift voucher balance is still showing in my account. It won't let me redeem the voucher, but will let me send it to someone. In admin the voucher shows as redeemed. The only thing I can think of is that with this transaction, I didn't return to checkout_success (because of any error with my payment processor) - would this be the reason? If not, any other ideas? Thank you.
  25. Ok, I have a bigger problem. I tried a transaction, and everything was fine.. apart from the fact that it re-directed me back to my shopping_cart page instead of checkout success??? Do I have to set something up in Nochex as well? Please help me! :blink:
×